Export (0) Print
Expand All
Expand Minimize

Transformation Options (Source Columns Tab)

SQL Server 2000

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

Show:
© 2014 Microsoft