How to copy one or more source columns to an unequal number of destination columns (DTS Designer)

To copy one or more source columns to an unequal number of destination columns

1. Click the Transformations tab.
2. Make sure ActiveX Script 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.
6. Click New.
7. In the ActiveX Script Transform Properties dialog box, enter your script in the selected language that describes the mapping between source or destination columns and one or more global variables.