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)
Syntax
'Declaration
Public Overridable Property DefaultBufferSize As Integer
Get
Set
'Usage
Dim instance As MainPipeClass
Dim value As Integer
value = instance.DefaultBufferSize
instance.DefaultBufferSize = value
public virtual int DefaultBufferSize { get; set; }
public:
virtual property int DefaultBufferSize {
int get ();
void set (int value);
}
abstract DefaultBufferSize : int with get, set
override DefaultBufferSize : int with get, set
function get DefaultBufferSize () : int
function set DefaultBufferSize (value : int)
Property Value
Type: System.Int32
The default size, in bytes, of the IDTSBuffer100 objects created by the task.
Implements
IDTSPipeline100.DefaultBufferSize
Remarks
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.