Task Host Container
You have worked with the package, the Foreach Loop Container, the For Loop Container, and the Sequence Container in BIDS by using their Editors or Properties windows. The Task Host Container is not available in BIDS so you can’t configure it directly and drop tasks in it. Task Host Container empowers a task to use features of a container such as use of Event Handlers.
The benefits of having a container design in SSIS include the following:
The variables can be shared among the tasks and child containers of a container.
The parent container can handle the events happening within a child container.
To empower the individual tasks to use these features, Task Host containers have been created. The Task Host container encapsulates ...
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.
