| What are the containers in SSIS and types
As we know containers is like a buket or a box which can holds different objects. Similarly in SSIS it is a objects which stores tasks. And its primary purpose is to group logical related tasks. And once we place the task in containsers we can do any operation on ths tasks for example we can do looping on container level until we desired. We can alos do nesting. And container is placed inside the control flow. Below are the 4 types of cotainers available in SSIS
1.Task Host container:- we can place one task inside the container and this is default container.
2.Sequence Container:- This type of container can be defined as subset of package control flow.
3.For loop container:- This types Allow looping based on condition. Runs a control flow till condition is met.
4.For each loop container:- In this we loop through container based on enumerator. | | |