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
AX columns are Unicode. So I have put data conversion on
TXT columns to Unicode
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???