Pro SQL Server 2005 Integration Services contains everything you could ever hope to know about this exciting new development from Microsoft: developer insight, Microsoft group manager–level access, personal experience of using the technology in the real–world, and fine–grained analysis. If you want to rapidly gain knowledge and context from your data, Microsoft’s latest and greatest interpretation of Enterprise Application Integration, SQL Server Integration Services, is for you. As part of the extensive SQL Server suite, Integration Services is a more serious and expandable interpretation of the integration paradigm than previously available. At once both simple to use yet incredibly complex, it goes far beyond being a reimagining and reengineering of DTS, and its all presented in a familiar Visual Studio context. It’s Agile, it’s service-oriented, it’s everything to everyone.

Written for the developer, the DBA, and the data artisan, Pro SQL Server 2005 Integration Services will show you how to develop and deploy enterprise SSIS solutions in multibillion–item environments. Its everything SSIS, explained for everyone!

What you’ll learn

- Understand how to develop and deploy SSIS solutions that will perform in multibillion–item environments from an author who has been there and done it.

- Build bespoke custom components tailored to your projects exact requirements.

- Create perfomant and scalable solutions with an eye to future requirements and upgrades.

Who this book is for

This book is for anyone working with SQL Server who has an interest in the Integration Services technology. Deep experience of SQL Server 2005 is not expected, however, you should be comfortable with fundamental techniques.