Creating DTS ActiveX Scripts

In DTS, Microsoft® ActiveX® scripts are optional programs, implemented as custom tasks, that you can add to package. Using a scripting language (Microsoft Visual Basic® Scripting Edition, Microsoft JScript®, or PerlScript) and the objects, methods, properties, and collections of the DTS object model, ActiveX scripts add power, programmability, and customizability to a package. Using ActiveX scripts, you can:

• Code the transformation of each source column as it is copied to the destination.
• Create COM objects (such as an ADO connection).
• Dynamically change the properties of a DTS object.
• Create and set global variables.

Note ActiveX Scripts are described in detail with examples in DTS Designer. Additional examples are available in ActiveX Script Samples. Special consideration should be given to performance issues when you use ActiveX Scripts and other specialized DTS features.

See Also