Post reply

Bug with using two merge joins?

  • October 17, 2011 at 6:35 pm

    #146368

    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

  • October 18, 2011 at 9:07 am

    #1396053

    Did you set the transform so that it knows the source is sorted and on what?

  • October 18, 2011 at 4:22 pm

    #1396381

    How do I check that?

    The SQL source is sorted, one side from the multicast accepts the source as sorted but the other doesn't.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply