Hands-On Microsoft SQL Server™ 2005 Integration Services

For Loop Container

The For Loop Container is probably the easiest container to work with. If you have worked with programming languages, you must be aware of popular For Loop statements. Generally the syntax of these statements defines a numeric variable, with a starting value, the incrementing step, and the ending value, along with statements to be executed repeatedly till the end point is reached. The For Loop Container provides a similar functionality of repeating a task or group of tasks for a defined number of times in Integration Services. The For Loop Container iterates over and over while evaluating an expression with each repeat until the expression evaluates to False.

To understand this, consider a Send Mail Task configured inside the ...