I am creating an SSIS package that creates a flat file output from a SQL table. I want to change a status on each record in the table after the output is complete. At first I was going to call a Stored Proc that gathered the records and changed the status, but if the SSIS step fails then I won't be able to trace which records I need to reset.
Is there a way to use a multicast to write to an in-memory dataset, and once the flat file has been created, itterate through those records and reset them? Is that what a DataReader Destination is used for (Multicast into the flat file and into the DataReader)?