Udostępnij za pośrednictwem


IDTSPipeline90.DefaultBufferMaxRows Property

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

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

Syntax

'Declaration
<DispIdAttribute(117)> _
Property DefaultBufferMaxRows As Integer
[DispIdAttribute(117)] 
int DefaultBufferMaxRows { get; set; }
[DispIdAttribute(117)] 
property int DefaultBufferMaxRows {
    int get ();
    void set ([InAttribute] int plMaxRows);
}
/** @property */
/** @attribute DispIdAttribute(117) */ 
int get_DefaultBufferMaxRows ()

/** @property */
/** @attribute DispIdAttribute(117) */ 
void set_DefaultBufferMaxRows (/** @attribute InAttribute() */ int plMaxRows)
DispIdAttribute(117) 
function get DefaultBufferMaxRows () : int

DispIdAttribute(117) 
function set DefaultBufferMaxRows (plMaxRows : int)

Property Value

An integer that specifies the maximum number of rows contained in the IDTSBuffer90 objects created by the task.

Remarks

Updated text:17 July 2006

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 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.

See Also

Reference

IDTSPipeline90 Interface
IDTSPipeline90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

Change History

Release

History

17 July 2006

Changed content:
  • Provided the default value of the property.