Update: Amazon is now reporting a release date of 9/17 although it appears you can order it immediately from the O’Reilly site.

My second SSIS book – Microsoft SQL Server 2012 Integration Services (MS Press) – comes out on September 17th. This book takes a different approach than my Design Patterns book that came out last week – it’s more of an in-depth look at the internals of SSIS in SQL Server 2012, rather a problem/solution type of guide. My co-authors (Wee Hyong Tok, Rakesh Parida, Xiaoning Ding, and Kaarthik Sivashanmugam) are all members of the SSIS product team (or at least were when we started writing the book… Rakesh and Kaarthik have recently moved over to the Data Quality Services team), which allowed us to take a deep look into how the product was designed.

Here a full list of chapters – a sample chapter is available from the O’Reilly website.

• Chapter 1 : SSIS Overview
• Chapter 2 : Understanding SSIS Concepts
• Chapter 3 : Upgrading to SSIS 2012
• Chapter 4 : New SSIS Designer Features
• Chapter 5 : Team Development
• Chapter 6 : Developing an SSIS Solution
• Chapter 7 : Understanding SSIS Connectivity
• Chapter 8 : Working with Change Data Capture in SSIS 2012
• Chapter 9 : Data Cleansing Using SSIS
• Chapter 10 : Configuration in SSIS
• Chapter 11 : Running SSIS Packages
• Chapter 12 : SSIS T-SQL Magic
• Chapter 13 : SSIS PowerShell Magic
• Chapter 14 : SSIS Reports
• Chapter 15 : SSIS Engine Deep Dive
• Chapter 16 : SSIS Catalog Deep Dive
• Chapter 17 : SSIS Security
• Chapter 18 : Understanding SSIS Logging
• Chapter 19 : Automating SSIS
• Chapter 20 : Troubleshooting SSIS Package Failures
• Chapter 21 : SSIS Performance Best Practices
• Chapter 22 : Troubleshooting SSIS Performance Issues
• Chapter 23 : Troubleshooting Data Issues