ActiveX Script Task Properties
New Information - SQL Server 2000 SP3.
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).
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.
This tab lets you specify the scripting language and the functions to use in the ActiveX script.
- 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.
- 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.
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.
Security Note Scripts can be the source of security vulnerabilities; they can invoke system functions without user knowledge or intervention and may contain security credentials in plain text. Review the script for security issues before use. For more information, see Security and Scripting.
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.
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.
Check the code for syntax errors.
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.
Reverse a limited number of text entry actions. You cannot undo actions such as adding code through the Select File dialog box.