Export (0) Print
Expand All

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)

public virtual int DefaultBufferSize { get; set; }

Property Value

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft