MainPipeClass.DefaultBufferSize Property

  • Article

 

Applies To: SQL Server 2016 Preview

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

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

Syntax

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

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

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

<DispIdAttribute(120)>
Public Overridable Property DefaultBufferSize As Integer

Property Value

Type: System.Int32

The default size, in bytes, of the IDTSBuffer100 objects created by the task.

Implements

IDTSPipeline100.DefaultBufferSize

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 Data Flow Performance Features.

See Also

MainPipeClass Class
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

Return to top