Rich Parsons (2/2/2015)
This was helpful, so thanks.I needed to use a Derived Column transform, then a Sort, and undo the IsSorted and SortKeyPosition, before the Merge Join would work. I'm still annoyed, however, that I needed to trim the nvarchars in the first place, in order to get a match!
So, are you sorting on the Derived column then? If not then why can't you do the sort using an ORDER by in the source query - much faster as an earlier poster has already said?
Regards
Lempster