Hi All,
In my data flow task. I have two merge joins after a multicast and the right hand side merge join says there is an error; "Error Merge right join is not sorted".
But both merge joins are using the same source(sorted) for the right sided join and the other merge join works fine.
So is there a bug with SSIS using two merge joins from a multicast or something I have missed?
Thanks for help