Microsoft SQL Server 2005 Integration Services

Chapter 13. Looping and Foreach Enumerators

IN THIS CHAPTER

• The For Loop

• The Foreach Loop

• Stock Foreach Enumerators

“IT’S ALWAYS EMPTY, AT LEAST WITH RESPECT TO BEING FULL.”—KAMAL HATHI

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.

The For Loop

The For Loop is really a pretty simple container. It is useful when you need to execute the same workflow repeatedly for a given ...