Skip to main content

Default Buffer Max Rows

SSIS Data Flow configuration for Default Buffer Max Rows for supported destinations. Override the value here to change the default SSIS behavior.

The value is applied as the DefaultBufferMaxRows property on the data flow tasks in the generated packages, controlling the maximum number of rows per data flow buffer. The default 10000 matches the SSIS default.

When to Change This Setting​

Tune this together with Default Buffer Size: for narrow rows, a higher row cap lets each buffer carry more data; for wide rows the buffer size limit is reached first and raising the row cap has no effect. When Auto Adjust Buffer Size is active, the buffer size is calculated from this row count.

SettingInteraction
Default Buffer SizeThe companion size limit per data flow buffer
Auto Adjust Buffer SizeSizes buffers automatically from this row count on supported SSIS versions
Buffer Temp Storage PathWhere buffers spill when memory is exhausted

Notes​

  • This setting is part of the SSIS settings category.
  • The default value for this setting is 10000.