I have a simple data flow. I'm trying to join two sets of data from two different databases. The
AX columns are Unicode. So I have put data conversion on
However no matter what I do I cannot get rid of 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
.

TXT
columns to Unicode

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???
Asked by jhowe
(271 rep)
Feb 27, 2015, 12:47 PM
Last activity: Mar 27, 2024, 10:50 AM
Last activity: Mar 27, 2024, 10:50 AM