The Rational Guide to Extending SSIS 2005 with Script

The Integration Services feature of Microsoft® SQL Server 2005 brings together data from diverse sources in a high-performance data integration platform, to enable users to work across multiple applications that may not have been designed to cooperate. In this book, Donald Farmer, Microsoft's Group Program Manager for SQL Server Integration Services, clearly explains how to build practical and useful scripts for this exciting new SQL Server 2005 feature. His systematic approach, friendly tutorials, and numerous examples are suitable for both developers and IT professionals alike. You'll learn how scripting in SQL Server Integration Services can enable you to easily add new, fully-integrated functionality to achieve your enterprise data integration needs.

This book takes a rational, no-nonsense approach in a compact guide - only 224 pages. The book is written to give you the basics...fast!

Technical Accuracy is assured by Ashvini Sharma, Development Lead, SQL Server Integration Services, Microsoft Corporation.

* Bonus Chapter: "Monitoring SSIS Performance with Scripts"
* Bonus Chapter: "Accessing Web Services with SSIS Scripts"
* Bonus Chapter: "Using SSIS as a Data Service"
* Sample code for the examples in the book

Donald Farmer is the Group Program Manager of the SQL Server Integration Services team at Microsoft. Donald has worked with SQL Server Business Intelligence tools since they first made an appearance in SQL Server 7.0, first working in Scotland for an independent software vendor before joining Microsoft itself. A well-known speaker at SQL Server events, Donald frequently draws on experiences from his varied career--which includes construction, archaeology, and fish farming--to illustrate the importance of analytic software in the real world.