Expert SQL Server 2005综合应用教程 Expert SQL Server 2005 Integration Services

As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.

作者简介：
　　Brian Knight (SQL Server MVP, MCSE, MCDBA) of Green Cove Springs, Florida, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). He is a contributing columnist for SQL Server Standard and also maintains a regular column for the database web site, SQLServerCentral.com, as well as doing regular webcasts at JumpstartTV.com. He has co-authored and authored more than nine SQL Server books, including Admin911: SQL Server 2000 (McGraw-Hill Companies, 2001), Professional SQL Server 2000 DTS (Wiley Publishing, 2000), Professional SQL Server 2005 Administration (Wiley Publishing, 2006), and Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). He has spoken at conferences such as PASS, SQL Connections, and TechEd, as well as at many Code Camps. His blog can be found at www.whiteknighttechnology.com. He is an independent consultant at Pragmatic Works and spends most of his time trying to think about how to use the word onomatopoeia in everyday sentences.

Acknowledgments.
Introduction.
Chapter 1: Getting Started.
　Choosing the Right Tool for the Job
SSIS Review
Summaty
Chapter 2: Extending Scripts in SSIS.
Script Tasks and Custom Libraries
Building a Custom Assembly
Making Connections Configurable and Dynamic
Raising Error Events
Encrypting Data Through Script Components
Data Profiling
Summary
Chapter 3: Data Extraction.
Package Connections and Data Flow Sources
Incremental Data Extraction
Tracking Data Lineage Identifiers
Srmmary
Chapter 4: Dimension ETL with SSIS.
Dimension ETL Overview
Dimensions:The Basics
Dimension ETL:The Challenge
SSIS Slowly Changing Dimension Wizard
Creating a Custom Slowly Changing Package
Summary
Chapter 5: Fact Table ETL.
Fact Table Overview
Fact Table ETL
Fact Table ETL Challenge
……
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.
Chapter 11: Migrating from DTS to SSIS.
Chapter 12: Scaling SSIS.
Index.