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