Export (0) Print
Expand All

MainPipeClass.DefaultBufferMaxRows Property

Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer.

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

public virtual int DefaultBufferMaxRows { get; set; }

Property Value

Type: Int32
An Integer that specifies the maximum number of rows contained in the IDTSBuffer100 objects created by the task.



The default value of this property is 10,000 rows.

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