SSIS Multicast - Wait for one fork to finish before executing next fork

Question

I have an SSIS Mulitcast object that splits my flow into 2 paths.

In the first path I insert the flow into another database.

In the second path I update the rows of the flow to show that they were inserted.

I need a way to make one path wait until the other path has finished. (So I can handle any insert errors and not update the rows for those that were errors.)

Any Help is appreciated.

Answer 1

I looked into this more and here is the answer I came up with:

On each output of the multicast I put a sort operation, then I join them using a MergeJoin operation. After that I do a SQL Update using an OLE DB command on the items that don't have an error value from the mergejoin.