Integration Services supports looping intrinsically with two containers called the For Loop and the Foreach Loop. These containers provide a way to repeatedly execute the same workflow in a controlled way. The For Loop uses expressions to determine when the loop should terminate. The Foreach Loop executes the body of the loop once for each item in a collection and terminates after the last element in the collection. |