MainPipeClass.VariableDispenser Property
Sets the IDTSVariableDispenser100 used to lock variables in a package for reading and writing.
Namespace: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)
Syntax
'Declaration
Public Overridable WriteOnly Property VariableDispenser As IDTSVariableDispenser100
Set
'Usage
Dim instance As MainPipeClass
Dim value As IDTSVariableDispenser100
instance.VariableDispenser = value
public virtual IDTSVariableDispenser100 VariableDispenser { set; }
public:
virtual property IDTSVariableDispenser100^ VariableDispenser {
void set (IDTSVariableDispenser100^ value);
}
abstract VariableDispenser : IDTSVariableDispenser100 with get, set
override 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.
Implements
IDTSPipeline100.VariableDispenser
Remarks
The IDTSVariableDispenser100 object is used to read and write variables in the package containing the data flow task. Before reading or writing a variable it must be locked using the LockForRead method, the LockForWrite method, the LockOneForRead method, or the LockOneForWrite method. After locking the variables using 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.