ActiveX Script Task Properties

DTS Designer

DTS Designer Help

ActiveX Script Task Properties

Use this dialog box to specify the code that will perform the functions you need to customize your Data Transformation Services (DTS) package (for example, skipping a row of source data that contains invalid data).

Options

Description

Specify a description for the Microsoft® ActiveX® Script task. This description becomes the label for the task icon placed on the DTS Designer design sheet.

Language tab

This tab lets you specify the scripting language and the functions to use in the ActiveX script.

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 on 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 an ActiveX Script task.

Browser tab

View the tree that contains the return code constants, the package global variables, and the lookups available for use in the ActiveX script. To copy information into the ActiveX script text box, expand the nodes and double-click on an item.

ActiveX script text box

Write 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 and a line of code containing the return code, if supported by the selected scripting language.

Important  If there is scripting code in the ActiveX script text box, 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, the contents of that file are copied into the ActiveX script text box.

Important  Opening an external script file from the Select File dialog box will overwrite any existing code in the ActiveX script text box. Therefore, always select code files before inserting any other code into the box.

Parse

Check the code for syntax 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 DTS

Using Global Variables with DTS Packages

Debugging ActiveX Scripts

Using Return Codes in DTS

ActiveScriptTask Object