MainPipeClass.DefaultBufferSize Property

Article
12/03/2008

Gets or sets the default size of the IDTSBuffer90 objects created by a task.

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

Syntax

'Declaration
<DispIdAttribute(120)> _
Public Overridable Property DefaultBufferSize As Integer Implements IDTSPipeline90.DefaultBufferSize

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

[DispIdAttribute(120)] 
public:
virtual property int DefaultBufferSize {
    int get () = IDTSPipeline90::DefaultBufferSize::get;
    void set ([InAttribute] int plDefaultBufferSize) = IDTSPipeline90::DefaultBufferSize::set;
}

J# supports the use of explicit interface implementations, but not the declaration of new ones.

JScript supports the use of explicit interface implementations, but not the declarations of new ones.

Property Value

The default size, in bytes, of the IDTSBuffer90 objects created by the task.

Remarks

Updated text:17 July 2006

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 Troubleshooting Package Performance.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Change History

Release	History
17 July 2006	Changed content: Noted default value of property.

Share via