SSIS: ForEach Loop Container

Performing complex, iterative actions.

In this example, I’ll illustrate how integrate iterative actions into a package.
This package will iterate through text files and display the name of each to the user.

As I explained in my Overview of Variables article, I’ll begin by adding an new Package Level variable and naming it Filename.

Next, I’ll drag a ForEach Loop Container Control Flow item unto the designer and configure it to loop through text files in my source folder.

For its Variable Mappings, I’ll select the Package-level variable I added in the first step.

2-ForEachLoop

Now I’ll drag a Script Task into the ForEach Loop Container configure its ReadOnlyVariables to use the package-level variable.

I’ll program the script to display the name of each file in my sources folder.

4-ForEachLoop

By executing my package, each file found in my source folder is displayed to me in a pop up window.

5-ForEachLoop

6-ForEachLoop

7-ForEachLoop

8-ForEachLoop

9-ForEachLoop

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s