Sort Transformation Editor

 

Applies To: SQL Server 2016

Use the Sort Transformation Editor dialog box to select the columns to sort, set the sort order, and specify whether duplicates are removed.

To learn more about the Sort transformation, see Sort Transformation.

Available Input Columns
Using the check boxes, specify the columns to sort.

Name
View the name of each available input column.

Passthrough
Indicate whether to include the column in the sorted output.

Input Column
Select from the list of available input columns for each row. Your selections are reflected in the check box selections in the Available Input Columns table.

Output Alias
Type an alias for each output column. The default is the name of the input column; however, you can choose any unique, descriptive name.

Sort Type
Indicate whether to sort in ascending or descending order.

Sort Order
Indicate the order in which to sort columns. This must be set manually for each column.

Comparison Flags
For information about the string comparison options, see Comparing String Data.

Remove rows with duplicate sort values
Indicate whether the transformation copies duplicate rows to the transformation output, or creates a single entry for all duplicates, based on the specified string comparison options.

Integration Services Error and Message Reference

Community Additions

ADD
Show: