SSIS-Sequence, Foreach, For loop containers

Recently one of my friend asked me a question like 

"when to use sequence container, For loop, and For each loop in SSIS"

Here I tried my best to explain the things in clear way

 What are SSIS Containers?

SSIS containers will be used to define the structure of control flow and reuse/repeat the control flow tasks for loading the multiple files data.

First we will see what is a sequence container in SSIS?

Sequence Container defines a control flow of the package and it group the multiple separate control flows into one container.

What is For Loop Containers in SSIS:

For Loop Containers are used for repeat the control flow of tasks in SSIS packages. Many of us know like how for loop works and in the same way For Loop Container will work. In each iteration it will evaluate the for loop condition and then repeats the control flow until the condition gets False.

In real time this will be used in a place like if we know how many iterations it has to do.

For e.g. In one folder contains, 10 employee‘s related files that we have to load into Database table. Here we know like we have to repeat the control flow process for 10 times. Sometimes we are not sure how many files will be placed from customer end and to handle these kinds of scenarios we have Foreach Loop Container in SSIS.

 What is Foreach loop Containers in SSIS:

When we don’t know how many files that we have to load into the table then we have to use Foreach loop Containers. It will repeat the loop till last file.

Most of SSIS Interview Questions, we will come across like what is the difference between “difference between sequence container , for loop container, and foreach loop container in ssis”

We will be discussing “ssis sequence container parallel execution” and “ssis sequence container execution order” in next post