My SSIS package looks like this:
Here text files are created from script task i.e "Unzip files". Now, files are named as A.txt to M.txt. Where will I have to specify out the filename so that this foreach can iterate.
Also, I am having A.txt file with me. I have added that file in File tab under Source Connection in Bulk Insert Task Editor.
Will this give a problem at runtime as file will get deleted on first step i.e Delete Zip Files.