Share via

  • Article

MainPipeClass.DefaultBufferSize Property

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

'Declaration
Public Overridable Property DefaultBufferSize As Integer
    Get
    Set
'Usage
Dim instance As MainPipeClass
Dim value As Integer

value = instance.DefaultBufferSize

instance.DefaultBufferSize = value

public virtual int DefaultBufferSize { get; set; }

public:
virtual property int DefaultBufferSize {
    int get ();
    void set (int value);
}

abstract DefaultBufferSize : int with get, set
override DefaultBufferSize : int with get, set

function get DefaultBufferSize () : int
function set DefaultBufferSize (value : int)

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 Improving the Performance of the Data Flow.