How to copy a single source column to a single destination column (DTS Designer)

To copy a single source column to a single destination column

1. Click the Transformations tab.
2. Make sure that Copy column is selected as the transformation type.
3. Drag the source column name to the destination column name.