ActiveX Script Task Editor (Script Page)

SQL Server 2008 R2

Use the Script page of the ActiveX Script Task Editor dialog box to select a scripting language and create a script for the ActiveX Script task.

To learn more about this task, see ActiveX Script Task.

Important noteImportant

The ActiveX Script task is provided only for purposes of backward compatibility with the deprecated component, Data Transformation Services (DTS). For more information, see Data Transformation Services (DTS).


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.


Select the scripting language to use from the list. The list of languages varies depending on the scripting engines installed on the local computer.


Type a script, or click the browse button (…) and type a script in the ActiveX Script dialog box, or click Browse to locate the file that contains the script.


Opening an external script file overwrites any existing code in the Script option.


Specify the name of the method that is the entry point in the script. This method is called from the ActiveX Script task when the task is run.


Locate the file that contains the script to use. When you click the file, the script is written to the Script option.


Save the script to a file.


Check the syntax of the script using the syntax checker for the script language specified in the Language option.

Community Additions