For Loop Container: looping through static enumerator till a condition is met

The For Loop Container is a method to create looping in the SSIS package Control Flow and is very similar to the For Loop structure that exists in programming languages. In this looping container, SSIS optionally initializes an expression and repeats its workflow until the expression evaluates to false.

As mentioned previously, this container repeats something until a condition in the EvalExpression property evaluates to true. Some examples could be as follows:

• Doing something n times

• Wait for some time (seconds, minutes, hours...) in each interaction until a specific action takes place; for example until a flag stored in a database changes

• Wait until a specific date and time to do something

To configure this container three important properties must be considered:

• InitExpression : An optional initialization expression for the loop counter.

• EvalExpression: This evaluates an expression and must be true, otherwise the...