Column Order

DTS Designer

DTS Designer Help

Column Order

Use this dialog box to view the names of the source and destination columns mapped in the transformation, and to change the source and destination columns included. You may need to change the order of the column mappings in transformations where there is an unequal number of source and destination columns (for example, where a single source column is copied to multiple destination columns).

Options

Columns text box

Edit column mappings by clicking a Source cell or Destination cell, selecting a column name or <ignore> from the list, and repeating the process for any additional Source and Destination cells.

See Also

Mapping Column Transformations

Copy Column Transformation

Transformation Types