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.

Community Additions

© 2015 Microsoft