Microsoft SQL Server 2005 Integration Services

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.

Related

Категории