This topic has not yet been rated - Rate this topic

IDTSOutput100.Buffer Property

SQL Server 2012

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

Namespace: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntax

C++

JScript

int Buffer { get; }

Property Value

Type: System.Int32
The integer ID of the PipelineBuffer assigned to the IDTSOutput100 object.

Remarks

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.

Examples

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);
    }
}

Reference

IDTSOutput100 Interface

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD