I have a simple data flow. I'm trying to join two sets of data from two different databases. The TXT database is collation SQL_Latin1_General_CP1_CI_AS. The other dataset (Cost) is coming from Dynamics AX which is Latin1_General_CI_AS.

enter image description here

AX columns are Unicode. So I have put data conversion on TXT columns to Unicode

enter image description here

However no matter what I do I cannot get rid of the MERGE JOIN ERROR and it's driving me insane.

TITLE: Microsoft Visual Studio

Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata.

Both datasets are set to sort by ITEMID (and I have set sort keys in both). Any ideas???

closed as off-topic by Paul White, dezso, Colin 't Hart, Martin Smith, Philᵀᴹ Feb 28 '15 at 20:08

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, dezso, Colin 't Hart, Martin Smith, Philᵀᴹ
If this question can be reworded to fit the rules in the help center, please edit the question.

  • um why was this downvoted? I have provided plenty of information... – jhowe Feb 27 '15 at 13:11

Whoops my bad! I was sure I had set the sort key on the advanced editor on ole db source but I hadn't!

Not the answer you're looking for? Browse other questions tagged or ask your own question.