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".
- ISBN10 0470101628
- ISBN13 9780470101629
- Publish Date 7 December 2007
- Publish Status Cancelled
- Out of Print 12 November 2014
- Publish Country US
- Imprint John Wiley & Sons Inc
- Format Paperback
- Pages 416
- Language English