SSIS Interview Question:

Explain the use of containers in SSIS and also their types?

Submitted by: Administrator

Containers can be defined as objects that stores one or more tasks. The primary purpose of container is grouping logically related tasks. Once the task is placed into the containers, we can perform various operations such as looping on container level until the desired criterion is met. Nesting of container is allowed. Container is placed inside the control flow. There are 4 types of Container:-

1. Task Host container- Only one task is placed inside the container. This is default container.
2. Sequence Container - This container can be defined as subset of package control flow.
3. For loop container - Allows looping based on condition. Runs a control flow till condition is met.
4. For each loop container - Loop through container based on enumerator.
Submitted by: Administrator