Share via

Script Task Editor (Script Page)

  • Article

Use the Script page of the Script Task Editor dialog box to set script properties and specify variables that can be accessed by the script.

Note

In SQL Server 2008 Integration Services (SSIS) and later versions, all scripts are precompiled. In earlier versions, you set a PrecompileScriptIntoBinaryCode property to specify that the script was precompiled.

To learn more about the Script task, see Script Task and Configuring the Script Task in the Script Task Editor. To learn about programming the Script task, see Extending the Package with the Script Task.

Options

  • ScriptLanguage
    Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.

    After you have created a script for the task, you cannot change the value of the ScriptLanguage property.

    To set the default scripting language for the Script task, use the Scripting language option on General page of the Options dialog box. For more information, see General Page.

  • EntryPoint
    Specify the method that the Integration Services runtime calls as the entry point into the code of the Script task. The specified method must be in the ScriptMain class of the Microsoft Visual Studio Tools for Applications (VSTA) project The ScriptMain class is the default class generated by the script templates.

    If you change the name of the method in the VSTA project, you must change the value of the EntryPoint property.

  • ReadOnlyVariables
    Type a comma-separated list of read-only variables that are available to the script, or click the ellipsis (…) button and select the variables in the Select variables dialog box.

    Note

    Variable names are case sensitive.

  • ReadWriteVariables
    Type a comma-separated list of read/write variables that are available to the script, or click the ellipsis (…) button and select the variables in the Select variables dialog box.

    Note

    Variable names are case sensitive.

  • Edit Script
    Opens the VSTA IDE where you can create or modify the script.

See Also

Tasks

Add, Delete, Change Scope of User-Defined Variable in a Package

Reference

General Page

Script Task Editor (General Page)

Expressions Page

Concepts

Integration Services Error and Message Reference

Script Task Examples

Integration Services (SSIS) Variables