SQLTeam.com | Weblogs | Forums

Text File Fails to Import to Table

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