Fill the gap between planning and doing with SSIS 2014
 
The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage.
* Implement new best practices for effective use of SSIS
* Work through tutorials for hands-on learning of complex techniques
* Read case studies that illustrate the more advanced concepts
* Learn directly from the foremost authority on SSIS
 
SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

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

Introduction xxvii
 
Chapter 1: Welcome to SQL Server Integration Services 1
 
Chapter 2: The SSIS Tools 17
 
Chapter 3: SSIS Tasks 39
 
Chapter 4: The Data Flow 99
 
Chapter 5: Using Variables, Parameters, and Expressions 165
 
Chapter 6: Containers 205
 
Chapter 7: Joining Data 219
 
Chapter 8: Creating an End-to-End Package 253
 
Chapter 9: Scripting in SSIS 275
 
Chapter 10: Advanced Data Cleansing in SSIS 335
 
Chapter 11: Incremental Loads in SSIS 363
 
Chapter 12: Loading a Data Warehouse 381
 
Chapter 13: Using the Relational Engine 429
 
Chapter 14: Accessing Heterogeneous Data 453
 
Chapter 15: Reliability and Scalability 497
 
Chapter 16: Understanding and Tuning the Data Flow Engine 529
 
Chapter 17: SSIS Software Development Life Cycle 563
 
Chapter 18: Error and Event Handling 591
 
Chapter 19: Programming and Extending SSIS 631
 
Chapter 20: Adding a User Interface to Your Component 689
 
Chapter 21: External Management and WMI Task Implementation 715
 
Chapter 22: Administering SSIS 767
 
Appendix A: SSIS Crib Notes 821
 
Appendix B: SSIS Internal Views and Stored Procedures 829
 
Appendix C: Interviewing for an ETL Developer Position 833
 
Index 839