Autorenportrait
InhaltsangabeIntroduction 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
Leseprobe
