Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foreach file enumeator not grabbing the other files

Status
Not open for further replies.

AzuMithu

Programmer
Jul 11, 2017
1
US
I am have about 53 csv files. My task is to import all the data from these files into one sql destination table. I am using a forech file container where the file is set to grab all files with the csv extension. The foreach container executes 53 times. But every time it is on the same file. It might look that it processed all files. But it is actually going the first file 53 times. Please suggest what I need to do. I have tried doing it the script task but no luck. Not sure where I am going wrong. I tried doing an array to add all the files. It works but not when it is placed in a container. Please help.

Thanks

 
Hi AzuMithu

I think the issue is how you configured you Flat File connection

Change it to expression in the properties, then it will be able to change the source to each file it is pointing to

Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top