O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

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

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

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