Professional Microsoft SQL Server 2008 Integration Services, Wrox Press

[ Pobierz całość w formacie PDF ]
Professional
SQL Server® 2008
Integration Services
Brian Knight
Erik Veerman
Grant Dickinson
Douglas Hinson
Darren Herbold
Wiley Publishing, Inc.
Professional SQL Server® 2008 Integration Services
Introduction .............................................................................................. xxix
Chapter 1: Welcome to SQL Server Integration Services ..................................1
Chapter 2: The SSIS Tools.............................................................................21
Chapter 3: SSIS Tasks ..................................................................................47
Chapter 4: Containers.................................................................................117
Chapter 5: The Data Flow ...........................................................................131
Chapter 6: Using Expressions and Variables ................................................199
Chapter 7: Joining Data ..............................................................................237
Chapter 8: Creating an End-to-End Package.................................................271
Chapter 9: Scripting in SSIS........................................................................293
Chapter 10: Loading a Data Warehouse.......................................................355
Chapter 11: Using the Relational Engine .....................................................413
Chapter 12: Accessing Heterogeneous Data................................................449
Chapter 13: Reliability and Scalability .........................................................491
Chapter 14: Understanding and Tuning the Data Flow Engine .......................521
Chapter 15: Source Control and Software Development Life Cycle ................567
Chapter 16: DTS 2000 Migration ................................................................609
Chapter 17: Error and Event Handling..........................................................623
Chapter 18: Programming and Extending SSIS.............................................661
Chapter 19: Adding a User Interface to Your Component ..............................717
Chapter 20: External Management and WMI Task Implementation ...............741
Chapter 21: Using SSIS with External Applications ......................................787
Chapter 22: Administering SSIS ..................................................................809
Chapter 23: Case Study: A Programmatic Example ......................................843
Index .........................................................................................................937
Professional
SQL Server® 2008
Integration Services
[ Pobierz całość w formacie PDF ]