Create New Transformation
Use this dialog box to select a transformation from the list to apply to the source and destination columns. The list includes all transformation types supplied with Data Transformation Services (DTS), as well as any custom transformations that were added and registered.
The most frequently used transformation types are Copy Column and ActiveX Script. Use Copy Column when you simply want to copy data from a source to a destination without transforming the data. Use ActiveX Script when you want to use scripting code to transform the data.