SSIS: File Iteration

Using custom C# code to iterative through files.

In this example, I’ll illustrate how to integrate custom 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-file-iteration

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-file-iteration

5-file-iteration

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

6-file-iteration

7-file-iteration 9-file-iteration 8-file-iteration

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