This topic has not yet been rated - Rate this topic

ScriptObjectModel.VariableDispenser Property

SQL Server 2008 R2

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

public VariableDispenser VariableDispenser { get; }

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