O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

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

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