Microsoft SQL Server 2008 Integration Services Problem-Design-Solution -- About the Authors -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Chapter 1: SSIS Solution Architecture -- Problem -- Design -- Solution -- Summary -- Chapter 2: SSIS Management Framework Design -- Problem -- Design -- Solution -- Summary -- Chapter 3: Package Deployment and Storage Decisions -- Problem -- Design -- Solution -- Summary -- Chapter 4: File-Handling and Processing Methods -- Problem -- Design -- Solution -- Summary -- Chapter 5: Data Extraction Best Practices -- Problem -- Design -- Solution -- Summary -- Chapter 6: Data-Cleansing Design -- Problem -- Design -- Solution -- Summary -- Chapter 7: Dimension Table ETL -- Problem - Fundamental Dimension ETL -- Design - Fundamental Dimension ETL -- Solution - Fundamental Dimension ETL -- Problem - Advanced Dimension ETL -- Design - Advanced Dimension ETL -- Solution - Advanced Dimension ETL -- Summary -- Chapter 8: Fact Table ETL -- Problem -- Design -- Solution -- Summary -- Chapter 9: SSAS Processing Architecture -- Problem -- Design -- Solution -- Summary -- Chapter 10: Implementing Scale-Out ETL Process -- Problem -- Design -- Solution -- Summary -- Chapter 11: Scripting Design Patterns -- Problem - Advanced File Management -- Design - Advanced File Management -- Solution - Advanced File Management -- Problem - Call Center Fact ETL -- Design - Call Center Fact ETL -- Solution - Call Center Fact ETL -- Summary -- Chapter 12: SSIS Package Scaling -- Problem -- Design -- Solution -- Summary -- Index.