文档介绍：Microsoft® SQL Server® 2008
Integration Services
Problem–Design–Solution
Erik Veerman
Jessica M. Moss
Brian Knight
Jay Hackney
Wiley Publishing, Inc.
v 9/24/09 12:00:03 PM
ii 9/24/09 12:00:03 PM
Microsoft® SQL Server® 2008 Integration Services
Problem–Design–Solution
Introduction ................................................................................................ xxv
Chapter 1: SSIS Solution Architecture .............................................................1
Chapter 2: SSIS Management Framework Design ..........................................33
Chapter 3: Package Deployment and Storage Decisions.................................75
Chapter 4: File-Handling and Processing Methods ..........................................97
Chapter 5: Data Extraction Best Practices ................................................. 119
Chapter 6: Data-Cleansing Design .............................................................. 167
Chapter 7: Dimension Table ETL ................................................................. 197
Chapter 8: Fact Table ETL ..........................................................................253
Chapter 9: SSAS Processing Architecture .................................................. 305
Chapter 10: Implementing Scale-Out ETL Process .......................................335
Chapter 11: Scripting Design Patterns ....................................................... 359
Chapter 12: SSIS Package Scaling .............................................................389
Index .........................................................................................................423
i 9/24/09 12:00:02 PM
Microsoft® SQL Server® 2008
Integration Services
Problem–Design–Solution
iii 9/24/09 12:00:03 PM
iv 9/24/09 12:00:03 PM
Microsoft®SQL Server®2008 Integration Services: Problem–Design–Solution
Published by
Wile