This topic has not yet been rated - Rate this topic

ScriptObjectModel.VariableDispenser Property

SQL Server 2012

Returns the VariableDispenser that can be used within the Script task to work with existing variables.

Namespace: Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly: Microsoft.SqlServer.ScriptTask (in Microsoft.SqlServer.ScriptTask.dll)

Syntax

C++

JScript

'Declaration
Public ReadOnly Property VariableDispenser As VariableDispenser 
	Get
'Usage
Dim instance As ScriptObjectModel 
Dim value As VariableDispenser 

value = instance.VariableDispenser

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.VariableDispenser
The VariableDispenser that can be used within the Script task to work with existing variables.

Remarks

Use the Variables property of the Dts object in Script task code to access variables, instead of using the VariableDispenser property. The Script task handles the locking semantics for you when you use the Variables property

Reference

ScriptObjectModel Class

Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD