Professional SQL Server 2008 Integration Services -- About the Authors -- Credits -- 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: Welcome to SQL Server Integration Services -- SQL Server SSIS Historical Overview -- What's New in SSIS -- Getting Started -- Architecture -- Precedence Constraints -- Containers -- Variables -- Data Flow Elements -- Error Handling and Logging -- Editions of SQL Server -- Summary -- Chapter 2: The SSIS Tools -- Import and Export Wizard -- Business Intelligence Development Studio -- Creating Your First Package -- The Solution Explorer Window -- The SSIS Package Designer -- Package Installation Wizard -- Management Studio -- Summary -- Chapter 3: SSIS Tasks -- SSIS Task Objects -- Looping and Sequence Tasks -- Scripting Tasks -- Analysis Services Tasks -- Data Flow Task -- Data Preparation Tasks -- RDBMS Server Tasks -- Workflow Tasks -- SMO Administration Tasks -- Summary -- Chapter 4: Containers -- Task Host Containers -- Sequence Containers -- Groups -- For Loop Container -- Foreach Loop Container -- Summary -- Chapter 5: The Data Flow -- The Data Flow -- Data Viewers -- Sources -- Destinations -- Transformations -- Data Flow Example -- Summary -- Chapter 6: Using Expressions and Variables -- The Paradigm -- Understanding Data Types -- Using Variables -- Working with Expressions -- Summary -- Chapter 7: Joining Data -- The Lookup Component -- The Merge Join Component -- Contrasting to the Relational Join -- New Lookup Features -- Building the Basic Package -- Using the Lookup Component -- Cache Connection Manager and Transform -- Summary -- Chapter 8: Creating an End-to-End Package -- Basic Transformation Tutorial.

Typical Mainframe ETL with Data Scrubbing -- Looping and the Dynamic Task -- Summary -- Chapter 9: Scripting in SSIS -- Scripting? -- Getting Started in SSIS Scripting -- Using the Script Task -- Using the Script Component -- Essential Coding, Debugging, and Troubleshooting Techniques -- Summary -- Chapter 10: Loading a Data Warehouse -- Data Profiling -- Data Extraction -- Dimension Table Loading -- Fact Table Loading -- SSAS Processing -- Master ETL Package -- Summary -- Chapter 11: Using the Relational Engine -- Data Extraction -- SQL Server 2008 Change Data Capture -- Data Loading -- Summary -- Chapter 12: Accessing Heterogeneous Data -- Excel and Access -- Oracle -- XML and Web Services -- Flat Files -- ODBC -- Other Heterogeneous Sources -- Summary -- Chapter 13: Reliability and Scalability -- Restarting Packages -- Package Transactions -- Error Outputs -- Scaling Out -- Summary -- Chapter 14: Understanding and Tuning the Data Flow Engine -- The SSIS Engine -- SSIS Data Flow Design and Tuning -- Pipeline Performance Monitoring -- Summary -- Chapter 15: Source Control and Software Development Life Cycle -- Introduction to Software Development Life Cycles -- Versioning and Source Code Control -- Code Deployment and Promotion from Development to Test to Production -- Summary -- Chapter 16: DTS 2000 Migration -- Managing DTS 2000 Packages within SQL Server Management Studio -- Running DTS 2000 Packages under SSIS -- Migrating DTS 2000 Packages to SSIS -- Using the Package Migration Wizard -- Third-Party Migration Solution -- Summary -- Chapter 17: Error and Event Handling -- Precedence Constraint -- Event Handling -- Breakpoints -- Error Rows -- Logging -- Summary -- Chapter 18: Programming and Extending SSIS -- The Sample Components -- The Pipeline Component Methods -- Building the Components -- Using the Components -- Upgrading to SQL 2008.

Summary -- Chapter 19 :Adding a User Interface to Your Component -- Three Key Steps -- Building the User Interface -- Further Development -- Other Considerations -- Summary -- Chapter 20: External Management and WMI Task Implementation -- External Management of SSIS with Managed Code -- Application Object Maintenance Operations -- Package Log Providers -- Package Configurations -- Windows Management Instrumentation Tasks -- Summary -- Chapter 21: Using SSIS with External Applications -- InfoPath Documents -- ASP.NET Applications -- Winform .NET Applications -- Summary -- Chapter 22: Administering SSIS -- Package Configuration -- Deployment Utility -- The Package Store -- Management Studio -- Running Packages with DTExecUI -- Security -- Command-Line Utilities -- Scheduling a Package -- Proxy Accounts -- 64-Bit Issues -- Performance Counters -- Summary -- Chapter 23: Case Study: A Programmatic Example -- What You Will Take Away -- Background -- Business Problem -- Solution Summary -- Solution Architecture -- Data Architecture -- Case Study Load Packages -- Case Study Invoice Matching Process -- Creating a Parent Driver Package -- Summary -- Index.