Summary

These containers have proven useful for a number of applications. For Loops are useful when you need to iterate multiple times and terminate based on a variable that might change by either directly modifying it in an expression or through some component inside or outside the loop. The Foreach Loop provides a way to drive workflow with collections of various types. Foreach Enumerators can enumerate collections of single types or collections of collections. There are Foreach Enumerators for enumerating over files, generic collections, schema rowsets, SMO objects, statically defined collections of strings or ADO rowsets, and datasets.