How to copy multiple source columns to an equal number of destination columns (DTS Designer)

To copy multiple source columns to an equal number of destination columns

1. Click the Transformations tab.
2. Make sure that Copy column is selected as the transformation type.
3. If the columns are already mapped, select the desired Source table and Destination table mappings, and then click Delete.
4. Press CTRL, and then click the desired Source table column names.
5. Press CTRL, and then click the desired Destination table column names. Make sure the number of source columns is equal to the number of destination columns.
6. Click New.