Udostępnij za pośrednictwem


IDTSPipeline90.VariableDispenser Property

Sets the IDTSVariableDispenser90 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
<DispIdAttribute(119)> _
WriteOnly Property VariableDispenser As IDTSVariableDispenser90
[DispIdAttribute(119)] 
IDTSVariableDispenser90 VariableDispenser { set; }
[DispIdAttribute(119)] 
property IDTSVariableDispenser90^ VariableDispenser {
    void set ([InAttribute] IDTSVariableDispenser90^ );
}
/** @property */
/** @attribute DispIdAttribute(119) */ 
void set_VariableDispenser (/** @attribute InAttribute() */ IDTSVariableDispenser90 )
DispIdAttribute(119) 
function set VariableDispenser ( : IDTSVariableDispenser90)

Property Value

The IDTSVariableDispenser90 for the data flow task.

Remarks

The IDTSVariableDispenser90 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 IDTSVariables90 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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

IDTSPipeline90 Interface
IDTSPipeline90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace