Buffer size is not set correctly when AutoAdjustBufferSize is enabled in SQL Server Data Tools in Visual Studio 2015

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you create a SQL Server Integration Services project package by using SQL Server Data Tools in Visual Studio 2015. When you set the value of the AutoAdjustBufferSize property to True, the buffer size is not set correctly when the data flow engine handles blob data. Therefore, the package may run more slowly than expected.

Resolution


The fix for this issue is included in the following cumulative update for SQL Server:


Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology  that Microsoft uses to describe software updates.