• 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!