O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required