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)

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

Property Value

Type: Int32
The default size, in bytes, of the IDTSBuffer100 objects created by the task.

Implements

IDTSPipeline100.DefaultBufferSize

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.

Community Additions

ADD
Show:
© 2015 Microsoft