Sample Header Ad - 728x90

SSIS Merge Join Error

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