Monday, December 1, 2008

Where is the IsSorted Property of Data Flow Source

When a merge join transformation is configured, we see an error saying the input is not sorted.

Wondered where the IsSorted Property was!
Select the source,
hit F4 then click on Show Advanced Editor. Here you will find the IsSorted, which by default is False and which needs to be changed to True.
















And then select the column to be sorted and set the sort order property.