IDTSPipeline100.DefaultBufferSize Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets or sets the default size of the IDTSBuffer100 objects created by the task.

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

Syntax

[DispIdAttribute(120)]
int DefaultBufferSize {
    [DispIdAttribute(120)]
    get;
    [DispIdAttribute(120)]
    set;
}

[DispIdAttribute(120)]
property int DefaultBufferSize {
    [DispIdAttribute(120)]
    int get();
    [DispIdAttribute(120)]
    void set(int value);
}

[<DispIdAttribute(120)>]
abstract DefaultBufferSize : int with get, set

<DispIdAttribute(120)>
Property DefaultBufferSize As Integer

Property Value

Type: System.Int32

An integer that contains the default size, in bytes, of the IDTSBuffer100 objects created by the task.

Remarks

The default value of this property is 10 megabytes, with a maximum of 100 megabytes.

For a brief discussion of this property and related properties that can be used to optimize the performance of the Data Flow task, see the section "Improving the Performance of the Data Flow Task" in Data Flow Task.

See Also

IDTSPipeline100 Interface
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

Return to top