create a package level variable named FileToImport
assign it the full path of the file it is looping on
pass it as a variable to your SQL Task
yosiasz, your idea worked perfectly. The Bulk Insert is now working for the Dynamic File connection and it is processing all the files. I learned a lot. Thank you very much!
1 Like