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
Thanks