Workflow ActiveX Script Properties

DTS Designer

DTS Designer Help

Workflow ActiveX Script Properties

Use this dialog box to specify the scripting code that will perform the functions you need to customize a Data Transformation Services (DTS) package step (for example, retrying a connection).

Options

Language Tab

This tab contains a list of the functions available in the language that you choose in the Language list.

Language
Select an available scripting language. When you install scripting languages on the computer, this list will update automatically. Microsoft® Visual Basic® Scripting Edition (VBScript) and Microsoft JScript® are available by default.
Functions
Select a function from the script language library to be placed into the ActiveX script text box. Double-clicking a function name inserts the function code into the text box at the position of the cursor.
Entry Function
Specify the name of the function that will be the entry point when the script runs. Only one function can be specified as an entry point for a workflow Microsoft ActiveX® script.

Browser Tab

View the constants available for use as return codes, package global variables, and lookups with a workflow ActiveX script. Click a tab to display the available information for selection, and double click on an item to copy the information into the ActiveX script text box.

ActiveX Script text box

Type or paste the scripting code necessary to perform the functions you need. The scripting editor has limited functionality; it does not include features such as statement completion or color-coding of reserved words. Comment lines use the apostrophe (') character syntax in any column, and all text from the comment character to the end of the line is ignored.

Auto Gen.

Generate a single function placeholder in the selected scripting language. This option may not work for all installed scripting engines.

Important  If there is scripting code in the ActiveX script text area, the code will be deleted when you click Auto Gen.

Browse

Display the Select File dialog box, where you can select a file containing code. When you select a file, this will copy the contents of that file into the ActiveX script text box.

Important  Opening an external script file from this dialog box will overwrite any existing code in the ActiveX script task text box. Therefore, this task should always be performed first.

Parse

Check the syntax of the code for errors.

Save

Display the Save As dialog box, where you can save all the code in the ActiveX script text box into a file on the local hard drive or on any mapped drive.

Undo

Reverse a limited number of text entry actions. You cannot undo actions such as adding code through the Select File dialog box.

See Also

Using ActiveX Scripts in a DTS Workflow

Using ActiveX Scripts in DTS

Using Global Variables with DTS Packages

Debugging ActiveX Scripts

Using Return Codes in DTS