Professional Microsoft SQL Server 2014 Integration Services

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