How to load data from multiple flat source files into a single flat file using SSIS?

Question

I've around 100 flat files(CSV) in a folder and I need to load them into a single text file. The column structure is same for all the source files and has to be the same in destination as well. I know, using Foreach container in SSIS, it can be done. Tried doing it so but the loop is not running and only one file data is be loaded into the destination and execution will finish. Please suggest to fix it so that loop runs through all the files in the source folder.

Thanks in advance, Krishna

AdamL · Accepted Answer · 2013-06-13 11:34:39Z

2

First of all, there are so many articles on looping through files in SSIS, that you should have no problem googling them.

But there's other solution than loops: use Multiple Flat Files manager. If all files have the same format, you just specify list of file paths, or use wildecard characters to filter the files, and you don't need to do anything else (provided that filenames themselves do not contain information you need to extract).

new manager

multiflatfile

answered Jun 13, 2013 at 11:34

AdamL

13.3k5 gold badges57 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to load data from multiple flat source files into a single flat file using SSIS?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related