Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL application that scales and performs to your specifications. You'll not only learn how to design and implement the necessary architecture, you'll also find out how to utilize the proper administration techniques.
Written by two SQL Server MVPs, this book first provides you with all the background and foundation information you'll need on scripting and data extraction. It then takes you through the details of data warehousing ETL, error handling, administration, and data integration. By following this approach, you'll quickly discover how to take advantage of SSIS functionality to meet your data integration and processing requirements.
Chapter 1: Getting Started
Chapter 2: Extending Scripts in SSIS
Chapter 3: Data Extraction
Chapter 4: Dimension ETL with SSIS
Chapter 5: Fact Table ETL
Chapter 6: Processing Analysis Services Objects with SSIS
Chapter 7: Package Reliability
Chapter 8: Deployment
Chapter 9: Managing SSIS
Chapter 10: Handling Heterogeneous and Unusual Data
etc