Share via


IDTSPipeline100.VariableDispenser Property

Sets the IDTSVariableDispenser100 used to lock variables in the package for reading and writing.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntax

'Declaration
WriteOnly Property VariableDispenser As IDTSVariableDispenser100 
    Set
'Usage
Dim instance As IDTSPipeline100 
Dim value As IDTSVariableDispenser100

instance.VariableDispenser = value
IDTSVariableDispenser100 VariableDispenser { set; }
property IDTSVariableDispenser100^ VariableDispenser {
    void set (IDTSVariableDispenser100^ value);
}
abstract VariableDispenser : IDTSVariableDispenser100 with get, set
function set VariableDispenser (value : IDTSVariableDispenser100)

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser100
The IDTSVariableDispenser100 for the data flow task.

Remarks

The IDTSVariableDispenser100 object is used to read and write variables in the package that contains the data flow task. Before reading or writing a variable, the variable must be locked by using one of the following methods: LockForRead, LockForWrite, LockOneForRead, or LockOneForWrite. After the variables are locked by the dispenser, they are accessible through the IDTSVariables100 interface. Because the variables are retrieved by name, you must know the name of the variable you want to read or write. It is not possible to enumerate the collection of variables.

See Also

Reference

IDTSPipeline100 Interface

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace