My SSIS package looks like this:

enter image description here

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.

Related posts

Recent Viewed