PipelineComponent.VariableDispenser Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Pipeline

Rakitan:

Microsoft.SqlServer.PipelineHost.dll

Penting

API ini bukan kompatibel CLS.

IDTSVariableDispenser100 Mendapatkan komponen aliran data.

public:
 property Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSVariableDispenser100 ^ VariableDispenser { Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSVariableDispenser100 ^ get(); };

[System.CLSCompliant(false)]
public Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser100 VariableDispenser { get; }

[<System.CLSCompliant(false)>]
member this.VariableDispenser : Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser100

Public ReadOnly Property VariableDispenser As IDTSVariableDispenser100

Nilai Properti

IDTSVariableDispenser100

Objek IDTSVariableDispenser100 yang disediakan untuk komponen.

Atribut

CLSCompliantAttribute

Contoh

Contoh berikut menunjukkan cara menggunakan VariableDispenser untuk mengunci satu variabel, dan beberapa variabel.

// Lock two variables, and then retrieve them by calling GetVariables.  
IDTSVariables100 variables = null;  

VariableDispenser.LockForRead("variable1");  
VariableDispenser.LockForRead("variable2");  
VariableDispenser.GetVariables(ref variables);  

object variable1 = variables[0].Value;  
object variable2 = variables[1].Value;  

// Retrieve a single variable.  
IDTSVariables100 variables = null;  
VariableDispenser.LockOneForRead("variable1", ref variables);  

object variable1 = variables[0].Value;  

' Lock two variables, and then retrieve them by calling GetVariables.  
Dim variables As IDTSVariables100 = Nothing   
VariableDispenser.LockForRead("variable1")   
VariableDispenser.LockForRead("variable2")   
VariableDispenser.GetVariables(variables)   
Dim variable1 As Object = variables(0).Value   
Dim variable2 As Object = variables(1).Value   
Dim variables As IDTSVariables100 = Nothing   
VariableDispenser.LockOneForRead("variable1", variables)   
Dim variable1 As Object = variables(0).Value  

Keterangan

VariableDispenser digunakan untuk membaca dan menulis variabel dalam paket yang berisi komponen. Sebelum membaca atau menulis variabel, variabel harus dikunci menggunakan salah satu metode berikut; LockForRead, , LockOneForReadLockForWrite, atau LockOneForWrite. Setelah variabel dikunci menggunakan dispenser, variabel tersedia melalui IDTSVariables100 antarmuka.