Due to the increased use use by BI professionals worldwide two recently published books discuss Biml. The first book, SQL Server 2012 Integration Services Design Patterns was released on September 8, 2012 and devotes a full chapter to Biml. This book was written by SSIS gurus Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ulford. This book is a terrific resource for learning Biml. The Biml chapter begins with a brief history and then explains step by step, with several screen shots, how to:

• Build your first Biml file inside of BIDS Helper
• Build a pattern for Basic Incremental Load in a SSIS package
• Use Biml as a SSIS Design Patterns Engine

In addition to the Biml chapter, Design Patterns covers 19 additional topics related to SQL Server 2012 that will help take your SSIS skills to the next level. SQL Server 2012 Integration Services Design Patterns is available through Amazon or Apress.

The second book Microsoft SQL Server 2012 Integration Services was released on September 19, 2012 and was written by members of Microsoft’s SQL Server Integration Services team. This book briefly talks about Biml as an alternative to creating SSIS automation solutions. This book will show you how to:

• Use SSIS to extract, transform, and load data from multiple data sources
• Apply best practices to optimize package and project configuration and deployment
• Manage security settings in the SSISDB catalog and control package access
• Work with SSIS data quality features to profile, cleanse, and increase reliability
• Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps
• Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

Both books are available for purchase through Amazon.