Script Task Editor (Script Page)
Applies To: SQL Server 2016
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.
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.
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.
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.
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.
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.
Opens the VSTA IDE where you can create or modify the script.
Integration Services Error and Message Reference
Script Task Editor (General Page)
Script Task Examples
Integration Services (SSIS) Variables
Add, Delete, Change Scope of User-Defined Variable in a Package