CODEWITHSUNDEEP
sql-serverssis
ShieldData
ShieldData

Reputation: 125

Folder of Flatfiles as Datasource SSIS

I am trying to automatically merge and upload all the .csv files contained in a folder with SSIS. Every month a new file is added and I would like to always have all the files in the folder to be uploaded. I don't want to updated the MULTIFLATFILES data connection every month to include the new file, but for it to be done automatically. Is this even possible? I haven't found a solution yet.

Upvotes: 0

Views: 25

Answers (1)

Chris Albert
Chris Albert

Reputation: 2507

Yes, this is possible. You can use a For Each Loop Container in SSIS to loop through all of the files in the folder. Take a look at this example for the basic structure of this typical SSIS pattern.

Upvotes: 1

Related Questions