SSIS Transformation Error [Resolved]

Posted by Sureshij under Sql Server on 1/31/2014 | Points: 10 | Views : 2546 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts