How to configure SSIS merge Join transformation

0
votes

enter image description here

The Excel Source has a column (ExcelColumn1) of type Unicode text stream[DT_NTEXT] and the OLE DB Source has a column(SQLColumn1) of type Unicode string[DT_WSTR]

I want to match and merge join results from the above two sources where

ExcelColumn1 = SQLColumn1

I have right clicked both sources, went to thier Advanced Editor dialogues, then to their input and output properties, then output columns, then the columns i want to sort by and set their sortkeyPosition from 0 to 1.

The isSorted property for both sources has also been set to True, but when i double click the Merge Join so i can configure the columns on which to join on, i am getting the error in the screenshot below. I can't seem to figure out what is wrong with my sources.

1
sql-serverssis

1 Answers

4
votes

Drag a Sort component for both the inputs : the sortid should be the same on the columns where you make a join,then configure merge join component.

see these links

1.http://www.bimonkey.com/2010/10/the-merge-join-transformation/

2.http://www.mssqltips.com/sqlservertip/1322/merge-multiple-data-sources-with-sql-server-integration-services/

If the error is with mismatch data type drag a Type conversion component and try joining with copy of column with other input !