Hello All,

I've got a loop (See http://www.sqldts.com/default.aspx?246) that loops
through a set of files downloaded from an FTP site. As I said in my
previous question, if the task fails to import the file, I've got to prevent
insertion of a file row in my file table so that when I manually fix the
file, I don't have to manually fix the DB also to allow the file to
reprocess (files inserted in the DB are blocked from processing again). So
my question is as follows:

If I insert an Execute SQL Task (inserts file row and records foreign key
for use in data pump) between "Begin Loop" and "Text File (Source)" and set
it and the data pump (#5) to join the current transaction and set the data
pump to commit or rollback based on the data pump's result, will this
accomplish my goal and reset properly for the next file (each file should be
in a separate transaction)?

Anyone see any problems?

Thanks,
Scott