Compartir a través de

  • Artículo

DefaultBufferMaxRows Propiedad

Gets or sets the maximum number of rows the task allows in an IDTSBuffer100 buffer.

Espacio de nombres:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Ensamblado:  Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)

Sintaxis

'Declaración
Public Overridable Property DefaultBufferMaxRows As Integer
    Get
    Set
'Uso
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)

Valor de la propiedad

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

Implementa

IDTSPipeline100. . :: . .DefaultBufferMaxRows

Comentarios

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 Mejorar el rendimiento del flujo de datos.