Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
File Inserter Transformation
By Allan Mitchell
Version 2005
Level Intermediate
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

Setup of the ForEachLoop Container

In the workflow section of our package we go to the toolbox and drag on the ForEachLoop container. Once on the designer we double click on the icon in the top left hand corner and we should see the following dialog

FEL Setup

In here we have chosen to iterate over a directory, we have chosen our directory and we have said that the files can basically be of any type here (*.*)

Although you can't see it yet, we'll show you in the next section, by adding the ForEachLoop container to the designer you have added a new system variable system::EnumeratedValue scoped to the container to the package.

Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7
Related Articles & Links
Read File Transformation