Contents at a Glance
Chapter 1 Introducing SQL Server Integration Services . . . . . . . . . . . . . . . . . . . . . 1
Chapter 2 Getting Started with Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
Chapter 3 Nuts and Bolts of the SSIS Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Chapter 4 Integration Services Control Flow Containers . . . . . . . . . . . . . . . . . . . . 109
Chapter 5 Integration Services Control Flow Tasks . . . . . . . . . . . . . . . . . . . . . . . . 135
Chapter 6 Administering Integration Services . . . . . . . . . . . . . . . . . . . . . . . . . . 225
Chapter 7 Securing Integration Services Packages . . . . . . . . . . . . . . . . . . . . . . . . 269
Chapter 8 Advanced Features of Integration Services . . . . . . . . . . . . . . . . . . . . . . 291
Chapter 9 Data Flow Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 333
Chapter 10 Data Flow Transformations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377
Chapter 11 Programming Integration Services . . . . . . . . . . . . . . . . . . . . . . . . . . . 481
Chapter 12 Data Warehousing and SQL Server 2008 Enhancements . . . . . . . . . . . . . . 535
Chapter 13 Deploying Integration Services Packages . . . . . . . . . . . . . . . . . . . . . . . 567
Chapter 14 Migrating to Integration Services 2008 . . . . . . . . . . . . . . . . . . . . . . . . 595
Chapter 15 Troubleshooting and Performance Enhancements . . . . . . . . . . . . . . . . . 631
Appendix How to Use the Provided Software . . . . . . . . . . . . . . . . . . . . . . . . . . . 673
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 677
