Foreach Item Enumerator in Foreach loop container in SSIS

Foreach Loop Container is one of the looping constructs available in SSIS packages. One of its enumerator options is the Foreach Item Enumerator. It enumerates through a list of items populated at design time. The list is static at execution time. We cannot load the list items dynamically from a configuration file or another source like an SQL table.

Let’s see how we use this Enumerator

Select Enumerator as Foreach Item Enumerator.

  

Now we need to click on the columns button to add the columns.

Here I am adding two column as Column 0 and column 1. Click Ok to add.

Adding some static product value.

Now we need to map this variable.

Click ok.

Now with the help of script task we can see this value.

Now I am running this package.

Executed successfully

Enjoy reading.