I have an ssis package the loops through an entire folder importing records into a sql 2005 database.
I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing from the folder it errors out my flat file destination and will not move on to the next. I tried diverting it to an error handler but no such luck.
BID 2005 Dev Ed