TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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)

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

Property Value

Type: System.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.

Return to top
Show:
© 2016 Microsoft