This seems a simple question but I can't find a clear answer anywhere...
I have an SSIS package that processes flat data files, one-by-one, in a loop, until there are no more files.
Before proceeding, I have to make sure the specified file exists. So I create a Script Task that checks for the file. File Exists = Task "Success" else Task "Fail".
I then branch from that task to either proceed with the Data Flow task, OR else to log a failure message.
IN EITHER CASE, I need to eventually return to the same cleanup Task in order to prepare for the next file.
However, if the failure pathway flows into the Cleanup task, then the Success pathway always terminates just before, and does not execute the Cleanup Task.
How can I ensure that two mutually exclusive pathways can return to the same Task?
View Complete Post