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.
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.
- 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.
