Freigeben über

  • Artikel

DefaultBufferMaxRows-Eigenschaft

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)

Syntax

'Declaration
Public Overridable Property DefaultBufferMaxRows As Integer
    Get
    Set
'Usage
Dim instance As MainPipeClass
Dim value As Integer

value = instance.DefaultBufferMaxRows

instance.DefaultBufferMaxRows = value

public virtual int DefaultBufferMaxRows { get; set; }

public:
virtual property int DefaultBufferMaxRows {
    int get ();
    void set (int value);
}

abstract DefaultBufferMaxRows : int with get, set
override DefaultBufferMaxRows : int with get, set

function get DefaultBufferMaxRows () : int
function set DefaultBufferMaxRows (value : int)

Eigenschaftswert

Typ: System. . :: . .Int32
An Integer that specifies the maximum number of rows contained in the IDTSBuffer100 objects created by the task.

Implementiert

IDTSPipeline100. . :: . .DefaultBufferMaxRows

Hinweise

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 Verbessern der Leistung des Datenflusses.