hi! We receive data feed from the client every day so the folders are created with datenames like 20160101,20160102 etc. There are five different csv files in each folder and the naming convention is same as the folder like test_20160101.csv,test2_20160101.csv. In this I need to pick only test2 csv files in different folders and load into a sql table.
Appreciate any suggestions Thank you
asked Jan 26, 2016 at 05:01 PM in Default
You should be able do this with SSIS. Are the file names consistent? Always test2 (whatever)?Use a ForEach loop to build a collection for the files that you want. The loop will iterate through children folders if you specify it to do so.
This is an older article but still valid:
Hope that helps!
answered Jan 26, 2016 at 05:05 PM