SSIS Transformation Error [Resolved]

Posted by Sureshij under Sql Server on 1/31/2014 | Points: 10 | Views : 1203 | Status : [Member] | Replies : 2
Error: The IsSorted property must be set to True on both sources of this transformation.
How to resolve the above error while using Merge Join transformation in SSIS

ij


Responses

Posted by: Bandi on: 1/31/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Some times Mrge Join transformation will give this error. The reason for this error is as follows:

Derived Column data flow transformation in SSIS will cause this issue. As a result of Derived Column, the IsSorted property is set to False. So you should set this property to True.

To set IsSorted = True :
1) Right click on "OLE DB Source" and then choose "Show Advance Editor"
2) Go to "Input and Output Properties"
3) Select "OLE DB Source Output " and then set IsSorted propery to True .
4) If you have more than one output columns then give "SortKeyPosition " for each output column by expanding "Output Column" in the "OLE DB Source Output "


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sureshij, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/7/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-merge-join-transformation/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sureshij, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response