ActiveX Script Transformation
New Information - SQL Server 2000 SP3.
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.
Security Note Scripts can be the source of security vulnerabilities; they can invoke system functions without user knowledge or intervention and may contain security credentials in plain text. Review the script for security issues before use. For more information, see Security and Scripting.
For more information about using ActiveX scripts or code examples, see Using ActiveX Scripts in DTS.