ActiveX Script Transformation
You can use a Microsoft® ActiveX® script to modify data as it is moved from its source to its destination. You can code a transformation between one or more source and destination columns.
You can write ActiveX transformation scripts in several places in the Data Transformation Services (DTS) user interface. However, an ActiveX Script transformation applies to tasks that work on source data on a row-by-row basis. Use it with:
- The DTS Import/Export Wizard.
- A Data Driven Query task.
- A Transform Data task.
For these items, the transformation scripts are executed for each row of data coming in from the source.
Note Because ActiveX Script transformations are executed for each row of data, place the code for opening and closing connections in such a way that a new connection is not opened and closed each time a row of data is processed.
For more information about using ActiveX scripts or code examples, see Using ActiveX Scripts in DTS.