Foreach Loop Container
While designing the workflow of an SSIS package, you may want to perform an operation on a collection. For example, you may want to read the names of the files in a folder and set the values of your variables using those names, or you may want to perform logic on each of the records in a table. The Foreach Loop container in SSIS provides this functionality by bringing the result set into the workflow; this lets you perform interesting work based on the data in the result set.
The Foreach Loop container defines an iterative workflow—that is, a repeating control flow in a package. This concept has been borrowed from programming languages. SSIS has made enumerating over a collection a lot easier by providing the Foreach Loop ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
