Sorting Merge Join output

Question

I have two merge joins in data flow task. I want to set the IsSorted property for inputs of second merge join. But it is giving error as "The IsSorted Property must be set to True on both sources of this transformation." following is the image of this:

UPDATE 1

From the answer and the comments below, the IsSorted property can be found in the Data sources (Excel + OLEDB) advanced editor. But the Merge Join Transformation doesn't have this property. And i need to Merge the first Merge Join output with the Excel Source without using a Sort component.

Answer 1

Update 2 (Workaround)

After the merge join add a script component in which you will add one output column (will be used as second join key). In the script just assign the original key value to this column.

Then in the script input and output properties, set the Output IsSorted property to True

Example:

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

    Output0Buffer.AddRow()
    Output0Buffer.outEmployeeName = Row.EmployeeName
    Output0Buffer.outEmployeeNumber = Row.EmployeeNumber
    Output0Buffer.outLoginName = Row.LogineName


End Sub

Update 1

If your are looking to generate Sorted output from the Merge Join transformation, then i recommend you to follow this link:

• Merge Join component sorted outputs [SSIS]

Initial Answer

The IsSorted property can be edited from the Advanced Editor,

Just right-Click on the OLEDB Source (or Excel Source if needed) , go to the Input and Output Properties, click on the Output and you will find the IsSorted property in the properties Tab

Then you souhld set the SortKeyPosition for the columns