DataPumpTransformScript Object
The DataPumpTransformScript object transforms source columns and moves data to the destination columns using a Microsoft® ActiveX® script. Columns can be transformed in any way supported by the scripting language. The driver for the specific ActiveX scripting language must be installed.
The DataPumpTransformScript object supports properties that are used to specify the script text, scripting language, and entry point name.
Properties
Remarks
Valid script languages available on a particular system can be determined by enumerating the ScriptingLanguageInfos collection of the Application object. For more information about the scripting language appropriate for use with Data Transformation Services (DTS), see ScriptingLanguageInfo Object.
The DataPumpTransformScript object is compatible with Microsoft SQL Server™ version 7.0. For more information about an extended version of this object, see DTSTransformScriptProperties2 Object.