A complete guide to Microsoft SSIS, updated for the 2014 release

Renowned SQL Server MVP Brian Knight and his expert co-authors teach you best practices for using all of the features of Microsoft SQL Server Integration Services (SSIS), including the latest enhancements introduced with the 2014 release of SQL Server. In addition to technical updates and additions, the authors also add a new set of best practices for effective use of SSIS, more case studies, and tutorial examples to illustrate advanced concepts and techniques.

Professional Microsoft SQL Server 2014 Integration Services:

• Explains how to extract, transform, and load (ETL) data with SSIS
• Covers each of the many SSIS tasks and Data Flow components
• Teaches you the most effective techniques for performance tuning SSIS
• Covers advanced techniques for data cleansing and incremental loads
• Shows how to load a data warehouse using built-in components in SSIS
• Details best practices for manageability and scalability