* The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)

* Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever

* Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques

* New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

Introduction:

Chapter 1: Welcome to SQL Server Integration Services

Chapter 2: The SSIS Tools

Chapter 3: SSIS Tasks

Chapter 4: Containers

Chapter 5: The Data Flow

Chapter 6: Using Expressions and Variables

Chapter 7: Joining Data

Chapter 8: Creating an End-to-End Package

Chapter 9: Scripting in SSIS

Chapter 10: Loading a Data Warehouse

Chapter 11: Using the Relational Engine

Chapter 12: Accessing Heterogeneous Data

Chapter 13: Reliability and Scalability

Chapter 14: Understanding and Tuning the Data Flow Engine

Chapter 15: Source Control and Software Development Life Cycle

Chapter 16: DTS 2000 Migration

Chapter 17: Error and Event Handling

Chapter 18: Programming and Extending SSIS

Chapter 19: Adding a User Interface to Your Component

Chapter 20: External Management and WMI Task Implementation

Chapter 21: Using SSIS with External Applications

Chapter 22: Administering SSIS

Chapter 23: Case Study: A Programmatic Example

Index