Export (0) Print
Expand All

IDTSPipeline100.DefaultBufferSize Property

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)

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

Property Value

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft