The Microsoft SSIS Team sent SSIS developers an early Christmas present this year: a new SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes:
Version 3.11 (Current Version):
- Release Date: December 23th, 2020
- Build Version: 15.0.2000.149
- Tested against Visual Studio 2019 16.8
- Whats’ new:
- Make creating SSISDB optional in IR Creation Wizard.
- Bug fixes:
- Fixed an issue that Azure Subscription ComboBox items are duplicate in IR Creation Wizard and Azure-Enabled Project Wizard when different subscriptions have the same name.
- Fixed an issue that auto-generated code under bufferwrapper.cs of script component adds extra double-quotes when current locale is Germany.
- Fixed an issue that download WSDL buttonis not displayed when target server version is SQL Server 2012, 2014, 2016.
- Fixed an issue that building large projects may fail due to out of memory exception.
- Fixed an issue that the package is not downgraded to current target server version of the project when it is saved as copy to file system or MSDB in package deployment model.
- Fixed an issue that Dimension Processing Destination doesn’t work due to “No such interface” error.
- Fixed some issues related to accessibility and high-DPI.
- Known issues:
- SQL Server Native Client (SQLNCLI11.1) is deprecated and not installed by VS2019. We recommend upgrading to the new Microsoft OLE DB driver for SQL Server. If you want to continue using SQL Server Native Client, you can download and install it from here.
- SSIS Execute Package Task doesn’t support debugging when ExecuteOutOfProcess is set to True.