Microsoft SQL Server 2012 Integration Services

Now available! Click here to find companion content downloads, errata, and details about book!

Conquer Microsoft® SQL Server® 2012 Integration Services — from the inside out!

You’re beyond the basics, so dive right in and really put SQL Server Integration Services to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts perform data integration tasks—and challenge yourself to new levels of mastery.

  • Gain in-depth understanding of Integration Service capabilities introduced in SQL Server 2012
  • Implement Integration Services best practices and design patterns
  • Master the ETL tool for data extraction, transformation, and loading
  • Manage performance issues using tuning principles and techniques
  • Diagnose problems and apply advanced troubleshooting features

Chapter List

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


Wee-Hyong Tok

Wee-Hyong Tok is a program manager on the SQL Server Integration Services team. He has worked on several different aspects of the product. Prior to joining Microsoft, Wee Hyong was a Microsoft MVP. He is a frequent presenter at Microsoft conferences. Wee Hyong is deeply passionate about how organizations can make use of business intelligence tools to derive business insights, and make better decisions.

Rakesh Parida

Rakesh Parida is a software development engineer on the SQL Server Integration Services team. He has worked on SSIS since SQL Server 2005, and was involved in many of the new features in this release, particularly ETL frameworks, data warehousing, and SSIS based solutions.

Matt Masson

Matt Masson is a senior software development engineer on the SQL Server Integration Services team. Matt joined the team shortly after the SQL Server 2005 release, and has worked on many aspects of the product. A frequent presenter at Microsoft conferences, he is heavily involved with the SSIS community, and maintains the SSIS Team Blog (

Xiaoning Ding

Xiaoning Ding is a software development engineer on the SQL Server Integration Services team, which he joined in 2007. He has worked on the SSIS engine, SSIS server, security model, and in other areas.

Kaarthik Sivashanmugam

Kaarthik Sivashanmugam is a lead software engineer on the SQL Server Integration Services team. Kaarthik joined the team during SQL Server 2005 launch and has been involved in several feature improvements to SSIS since then.