Buffer 屬性

Gets the ID of the PipelineBuffer allocated for an IDTSOutput100 object.

命名空間：  Microsoft.SqlServer.Dts.Pipeline.Wrapper
組件：  Microsoft.SqlServer.DTSPipelineWrap (在 Microsoft.SqlServer.DTSPipelineWrap.dll 中)

語法

'宣告
ReadOnly Property Buffer As Integer
    Get
'用途
Dim instance As IDTSOutput100
Dim value As Integer

value = instance.Buffer

int Buffer { get; }

property int Buffer {
    int get ();
}

abstract Buffer : int

function get Buffer () : int

屬性值

型別：System. . :: . .Int32
The integer ID of the PipelineBuffer assigned to the IDTSOutput100 object.

備註

This run-time property is primarily used as a parameter for the FindColumnByLineageID method of the BufferManager property to locate a column in a PipelineBuffer.

範例

The following code example locates the output columns in a buffer using FindColumnByLineageID. The indexes of the columns are stored in an internal member array so they can be accessed using either the PrimeOutput method or the ProcessInput method.

int []columnIndex;
public override void PreExecute()
{
    IDTSOutput100 output = ComponentMetaData.OutputCollection[0];

    columnIndex = new int[output.OutputColumnCollection.Count];

    for(int x=0; x< output.OutputColumnCollection.Count; x++)
    {
        IDTSOutputColumn100 col = output.OutputColumnCollection[x];
        columnIndex[x] = BufferManager.FindColumnByLineageID( output.Buffer,col.LineageID);
    }
}

Private columnIndex As Integer() 

Public  Overrides Sub PreExecute() 
 Dim output As IDTSOutput100 = ComponentMetaData.OutputCollection(0) 
 columnIndex = New Integer(output.OutputColumnCollection.Count - 1) {} 
 Dim x As Integer = 0 
 While x < output.OutputColumnCollection.Count 
   Dim col As IDTSOutputColumn100 = output.OutputColumnCollection(x) 
   columnIndex(x) = BufferManager.FindColumnByLineageID(output.Buffer, col.LineageID) 
   x -= 1 
 End While 
End Sub

請參閱

參考

IDTSOutput100介面

IDTSOutput100 成員

Microsoft.SqlServer.Dts.Pipeline.Wrapper 命名空間