Archive for June, 2010

SSIS ForEach loop container

Posted: 14 June 2010 in Uncategorized
Tags: ,
3

In this article I will describe how the For Each loop container works and how to make path references variable.

We have the following situation:

  • A source directory with flat files which we want to import. (source1.txt, source2.txt, source3.txt)
  • A destination directory to import the data. (destination.txt)

Source1.txt contains:

John;Doe;41
Jane;Smith;23
Peter;Pan;16

Source2.txt contains:

Jill;Valentine;23
Alex;Anderson;32

Source3.txt contains:

Mark;Vandenberg;54
Samantha;Smith;28

Destination.txt is empty. (more…)