DefaultBufferMaxRows 属性

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

命名空间:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
程序集:  Microsoft.SqlServer.DTSPipelineWrap(在 Microsoft.SqlServer.DTSPipelineWrap.dll 中)

语法

声明
Public Overridable Property DefaultBufferMaxRows As Integer
    Get
    Set
用法
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)

属性值

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

实现

IDTSPipeline100. . :: . .DefaultBufferMaxRows

注释

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 改进数据流的性能.