I am trying to combine several source tables with Merge Join. For the Moment I have three source tables all already sorted in the source query and the is sorted property with the correct keys set. (its an aggregate query with group by and sort by the
Then I do a merge join between two of the tables - with a full outer join.
Then I just want to do another merge join with the output of the next result. but as the merge join do not combine the key columns into one column I need to add a derived column which substitute null values on the left side of the join with values from the
right side of the join.
The second merge then says only the left columns of the first merge join is sorted, but not the comined columns. If i Replace with a derived column the left side primary key columsn with the combinded key columns the next merge join says the input is not
But the output must be sorted.
So how do I get the next merge join working without the ssis sort transformation? the data is sorted, but the component does not recognize the sorted data?
I do not want to use (can use) the sort because there are flowing >= 500 Mio. records through the pipeline.
Any help appreciated.
View Complete Post