SQL Server MVP Deep Dives, Volume 2

Chapter 48. Exploring different types of enumerators in the SSIS Foreach Loop container

Abolfazl Radgoudarzi and Shahriar Nikkhah

There are two types of loop structures in SQL Server Integration Services (SSIS): the For Loop container and the Foreach Loop container. The Foreach Loop container will loop through items in the specified collection, where the collection is divided into seven different enumerators. You may need to loop through files, items in a directory, records in a data table, nodes in XML data, and SMO objects.

Make it dynamic

Expressions provide a dynamic way of working in SSIS, particularly when combined with a Foreach loop. For example, you can change data sources in data flow tasks at runtime or change the path of an FTP ...