Transformation Options (Source Columns Tab)

DTS Designer

DTS Designer Help

Transformation Options (Source Columns Tab)

Use this tab to select and order the source columns you will use in the transformation. If you used the mapping lines on the Transformations tab of the Transform Data or Data Driven Query task to define the transformation, the source columns you mapped appear in the Selected columns list.

Options

Available columns

View the source columns from which you can select when creating the transformation.

Selected columns

View the source columns that will be used in the transformation.

>

Copy a selected column from the Available columns list to the Selected columns list.

>>

Copy all columns from the Available columns list to the Selected columns list.

<

Remove a selected column from the Selected columns list.

<<

Remove all columns from the Selected columns list and from the transformation.

See Also

Mapping Column Transformations

Transformation Types

Tasks That Transform Data