Skip to content

Latest commit

 

History

History
63 lines (48 loc) · 3.74 KB

File metadata and controls

63 lines (48 loc) · 3.74 KB
title Script Task Editor (Script Page) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology integration-services
ms.topic conceptual
f1_keywords
sql12.dts.designer.scripttask.script.f1
helpviewer_keywords
Script Task Editor
ms.assetid 93da0e0d-83f5-406d-b144-4cce216571cb
author janinezhang
ms.author janinez
manager craigg

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 [!INCLUDEssISversion10] 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 [!INCLUDEmsCoName] Visual Basic or [!INCLUDEmsCoName] 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 [!INCLUDEssISnoversion] runtime calls as the entry point into the code of the Script task. The specified method must be in the ScriptMain class of the [!INCLUDEmsCoName] [!INCLUDEvsprvs] 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

Integration Services Error and Message Reference
General Page
Script Task Editor (General Page)
Expressions Page
Script Task Examples
Integration Services (SSIS) Variables
Add, Delete, Change Scope of User-Defined Variable in a Package