Using ActiveX Scripts in a DTS Workflow

You can use Microsoft® ActiveX® scripts to customize the execution of steps in a Data Transformation Services (DTS) package. Because the code is run before the steps executes, you can use an ActiveX script in a workflow to:

• Restart a workflow.
  
  
• Turn off a step under certain conditions.
  
  
• Initiate retries of connections and other operations.
  
  
• Implement loop conditions.

You can also use a step ActiveX script to initialize or reference global variables. For more information, see Using Global Variables with DTS Packages.

To add ActiveX workflow scripts in DTS Designer