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

In that case I would not use a multicast but a regular dataflow so that one doesn't start before the first one completed successfully

Answer 2

You can't do that in SSIS. You can only enforce precedence constraints (i.e. enforce order of the run) at the Control Flow level.

Answer 3

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.