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 2005 Integration Services (SSIS) 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.
Options
Variable
Select an existing variable, or click <New variable...> to create a new variable.Note
After you map a variable, a new row is automatically added to the Variable list.
Related Topics: Integration Services Variables, Add Variable
Index
If using the Foreach Item enumerator, specify the index of the column in the collection value to map to the variable. For other enumerator types, the index is read-only.Note
The index is 0-based.
Related Topics: How to: Loop through Excel Files and Tables
- Delete
Select a variable, and then click Delete.
Change History
| Release | History |
|---|---|
17 July 2006 |
|
See Also
Reference
Foreach Loop Editor (General Page)
Foreach Loop Editor (Collection Page)
Expressions Page
Other Resources
Integration Services Error and Message Reference
For Loop Container