Skip to main content

Auto Adjust Buffer Size

SSIS Auto Adjust Buffer Size configuration for supported SQL Server versions.

When enabled (the default) and the project targets SSIS 2016 or later, the generated data flow tasks are given AutoAdjustBufferSize="true", so the data flow engine calculates the buffer size automatically from the configured row count instead of using the fixed default buffer size. For older target versions (SSIS 2005 through 2014) the property is not available and the setting has no effect. When disabled, the property is omitted, leaving the SSIS default (off).

When to Change This Setting​

Keep the default Y so buffer sizing adapts to row width automatically on modern SSIS versions. Disable it to manage buffer memory manually through Default Buffer Size and Default Buffer Max Rows.

SettingInteraction
Default Buffer Max RowsThe row count automatic sizing is based on
Default Buffer SizeThe fixed buffer size used when automatic sizing is off or unsupported

Notes​

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