Foreach Loop Editor (Variable Mappings Page)
Use the Variables Mappings page of the Foreach Loop Editor dialog box to map variables to the collection value. The value of the variable is updated with the collection values on each iteration of the loop.
To learn about how to use the Foreach Loop container in an Integration Services package, see Foreach Loop Container . To learn about how to configure it, see How to: Configure a Foreach Loop Container.
The Microsoft SQL Server Integration Services tutorial, Creating a Simple ETL Package Tutorial, includes a lesson that teaches you to add and configure a Foreach Loop. For more information, see Lesson 2: Adding Looping.