Export (0) Print
Expand All
Expand Minimize

Script Task Editor (Script Page)

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.

NoteNote

In SQL Server 2008 Integration Services (SSIS), 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 Using the Script Task to Extend a Package.

ScriptLanguage

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

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.

NoteNote

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.

NoteNote

Variable names are case sensitive.

Edit Script

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft