MainPipeClass.VariableDispenser Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Pipeline.Wrapper

Assembly:: Microsoft.SqlServer.DTSPipelineWrap.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 virtual property Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSVariableDispenser100 ^ VariableDispenser {  void set(Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSVariableDispenser100 ^ value); };

[System.Runtime.InteropServices.DispId(119)]
public virtual Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser100 VariableDispenser { [System.Runtime.InteropServices.DispId(119)] set; }

[<System.Runtime.InteropServices.DispId(119)>]
[<set: System.Runtime.InteropServices.DispId(119)>]
member this.VariableDispenser : Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser100

Public Overridable Property VariableDispenser As IDTSVariableDispenser100

Property Value

IDTSVariableDispenser100

The IDTSVariableDispenser100 for the data flow task.

Implements

VariableDispenser

Attributes: DispIdAttribute

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.

Applies to

Share via