Integration Services Objects
Integration Services relies on various objects and components such as connection managers, sources, tasks and transformations, containers, event handlers, and destinations to perform its operations. All these components are threaded together to achieve the desired functionality—that is, they work hand in hand, yet they can be configured separately.
The biggest enhancement Microsoft has provided to DTS 2000 to make it SQL Server 2005 Integration Services is the separation of workflow from the data flow. SSIS provides two different designer surfaces, which are effectively different integrated development environments (IDEs) for developing packages. You can design and configure workflow in the Control Flow Designer surface ...
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.
