Programming and Extending SQL Server 2005 Integration Services

The 2005 release of SSIS has been completely rewritten and has revolutionized Microsoft's database product suite.

This book examines how SSIS opens up a new world of integration possibilities by allowing custom code to be written in all of the .NET languages including C#.

Chapters examine each aspect of extending SSIS, including when and how it should be used, and then present a real-world case example showing how to do it and share vital information on how to avoid common pitfalls.

It includes discussions on the ability of SSIS to perform extraction, transformation, and load operations as well as its relationship with a relational database server, an OLAP server, an ETL platform, data mining, integrated reporting and notification, and the full integration of the .NET developer and database platforms.

It serves as a follow-on to one of Wrox's most successful titles, "Professional SQL Server 2005 Integration Services".