Adding a sort to the mapping group

After you create a mapping relationship between a source and a target, a mapping group is automatically created. You can define a sort on the target columns in the mapping group to refine the ORDER BY predicate that is created in the generated script.
Prerequisite:

To add a sort condition to the mapping group:

  1. In the Mapping Group view of the mapping editor, right-click a mapping line.
  2. Select one or more columns from the Available Columns pane and click the arrows to add the columns to the Selected Columns pane.
  3. In the Selected Columns pane, select the current value in the Order column to change the order. The values are ASC or DESC for ascending or descending.
  4. Click OK to add the sort expression to the target column.
Related concepts
Mapping groups

Feedback