Foreach file enumeator not grabbing the other files

[AzuMithu]

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

 

[Motlatjo]

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