Expert SQL Server 2005 Integration Services

When it comes to developing an enterprise ETL system, moving from theory to practice often presents the biggest hurdle. Not only can the primary data processing tasks be complex in themselves, but add in administration, error handling, scalability, testing and deployment and the result is like juggling spinning plates. It's no wonder why ETL consumes over 60 percent of an enterprise data warehouse development effort.


There are two keys to a successful ETL solution: using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements. With SQL Server 2005 Integration Services, half the battle is won. The out-of-the-box features provide the depth and breadth of functionality and flexibility needed to create scalable solutions. Even more, the usability and rapid learning curve reduce solution development time.


The second ingredient is correct ETL architecture and design. When considerable effort is spent testing scenarios and proving out designs, valuable testing, implementation, and deployment time is lost. This book fills that gap. As a practical guide for Integration Services ETL development, you will learn 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. Putting it all together to get a solution over the goal line requires knowing the big picture and coordinating all the pieces. The book, in short: ETL soup to nuts with Integration Services.

Dedication.

Foreword.

Preface.

Acknowledgments.

Author's Biographaphy.

Introduction.

1. Getting Started.

2. Extending SSIS.

3. Data Extraction.

4. Dimension ETL with SSIS.

5. Fact Table ETL.

6. Processing Analysis Services Objects with SSIS.

7. Package Reliability.

8. Deployment.

9. Managing SSIS.

10. Handling Heterogeneous and Unusual Data.

11. Migrating from DTS to SSIS.

12. Scaling SSIS.

Index.

Back of book ads.