SSIS Job looping over csv files

Question

How can I loop through multiple files in a data flow task .

Right now it raeds just one file , what to do if I need to read multiple files in a data flow task

For the referenced dupe, change the file extension from txt to csv — billinkc, Aug 11 '16 at 14:03

score 0 · Answer 1 · answered Aug 11 '16 at 08:45

There are a lot of things you could do (like moving/deleting the files after reading), but I will keep it just at reading the files.

Create a for each loop in your control flow. (this has to be done in the control flow.)
double click on the for each loop, and go to the collection tab.
Select for each file enumerator (in the drop-down)
Under enumerator configuration, select the right folder and write *.csv under Files. Under Retrieve file name, select fully qualified
Go to the variable mapping tab. Insert the variable CurrentFile with an Index of 0 (should be default)
Close the for each editor window. Add your dataflow in the for each loop container.
Open the dataflow and parametrize your connection manager. Use the variable CurrentFile.
You're ready to go

Some good material (with extras):

Hi Den , Thanks. I have done till step 6 but when I try to parameterize my connection manager , it throws an error .The acquire connection method calls to the connection manager fails . — Ritu, Aug 11 '16 at 09:35

1 Answers1