Summary

You have been introduced to Integration Services by following a couple of simple Hands-On exercises and reading a description of its architecture, features, and uses. You understand how various components of Integration Services work together to provide the manageability, flexibility, and scalability you need for your SSIS packages. You also appreciate the fact that all the components can be programmatically controlled and that custom tasks and transformations can be written using languages such as C++ or any CLR compatible language. You know that Integration Services has two separate engines that provide workflow and data flow functions. You are now ready to launch into the realm of bigger challenges.

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.