Skip to main content

Default Buffer Size

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

The value is applied as the DefaultBufferSize property on the data flow tasks in the generated packages, controlling the size in bytes of each data flow buffer. The default 10485760 (10 MB) matches the SSIS default.

When to Change This Setting​

Increase the buffer size for wide rows or high-throughput loads on machines with memory to spare, so each buffer carries more rows. Tune it together with Default Buffer Max Rows: whichever limit is reached first determines the buffer's row count. On SSIS versions that support it, Auto Adjust Buffer Size sizes buffers automatically instead.

SettingInteraction
Default Buffer Max RowsThe companion row cap per data flow buffer
Auto Adjust Buffer SizeAutomatic buffer sizing 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 10485760.