Professional SQL Server 2014 Integration Services covers the new features of the 2014 product release, expected in early 2014. The book reflects changes as how the product looks and works. In addition to technical updates and additions, the authors adds a new set of best practices for effective use of SSIS; more case studies, and tutorial examples to illustrate advanced concepts and techniques.

About the Author

Brian Knight, SQL Server MVP, MCDBA, is an independent consultant at Pragmatic Works and co-founder of SQLServerCentral.com. He runs the Jacksonville SQL Server Users Group, is a contributing columnist for SQL Server Standard, and writes a regular column for SQLServerCentral.com.

Table of Contents:
• Welcome to SQL Server Integration Services • The SSIS Tools • SSIS Tasks • The Data Flow • Using Variables, Parameters and Expressions • Containers • Joining Data • Creating an End-to-End Package • Scripting in SSIS • Advanced Data Cleansing in SSIS • Incremental Loads in SSIS • Loading a Data Warehouse • Using the Relational Engine • Accessing Heterogeneous Data • Reliability and Scalability • Understanding and Tuning the Data Flow Engine • SSIS Software Development Life Cycle • Error and Event Handling • Programming and Extending SSIS • Adding a User Interface to Your Component • External Management and WMI Task Implementation • Administering SSIS