ActiveX Script Task Editor (Script Page)

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

This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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.

Options

  • Language
    Select the scripting language to use from the list. The list of languages varies depending on the scripting engines installed on the local computer.
  • Script
    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.

    Note

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

  • EntryMethod
    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.
  • Browse
    Locate the file that contains the script to use. When you click the file, the script is written to the Script option.
  • Save
    Save the script to a file.
  • Parse
    Check the syntax of the script using the syntax checker for the script language specified in the Language option.

See Also

Reference

ActiveX Script Task Editor (General Page)
Expressions Page

Other Resources

Integration Services Error and Message Reference
Script Task
Creating Package Control Flow

Help and Information

Getting SQL Server 2005 Assistance