Testing New SSIS Extensions – Some Basics

Featured image test tube drawing attribution: Test Vectors by Vecteezy. How do I test new SQL Server Integration Services (SSIS) extensions and updates to Visual Studio? I have a collection of virtual servers that run locally on my laptop. SSIS extensions for Visual Studio 2019 and Visual Studio 2022 are now separate downloads (see the …
Continue reading Testing New SSIS Extensions – Some Basics

Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022

Update 19 Sep 2022: I communicated with the Microsoft SSIS Team. They shared they are targeting preview of VS2022 Integration Services Extension for the end of CY22. Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022. On 28 Jul 2021, the Microsoft SSIS Team released an …
Continue reading Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022

Updated SSIS Extension v3.16 for Visual Studio 2019

On 1 Jun 2021, the Microsoft SSIS Team released an update to version 3.16 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019. An operative bullet for this version: Version 3.16 is the latest general availability (GA) version, which does not support target server version …
Continue reading Updated SSIS Extension v3.16 for Visual Studio 2019

New SSIS Extension v3.15 for Visual Studio 2019

On 16 Aug 2021, the Microsoft SSIS Team released version 3.15 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning.   I am late getting this update published. Visual Studio 2019 v16.11.4 is now available… …
Continue reading New SSIS Extension v3.15 for Visual Studio 2019

New SSIS Extension v3.13.1 for Visual Studio 2019

On 12 Apr 2021, the Microsoft SSIS Team released version 3.13.1 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning. On 24 Apr 2021, the Integration Services extension was updated. The page displays this information …
Continue reading New SSIS Extension v3.13.1 for Visual Studio 2019

Updates to the SSIS Extension for Visual Studio 2019

On 25 Jan 2021, the Microsoft SSIS Team released version 3.12 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning that users rollback to v 3.11.1. The warning was issued 31 Jan 2021 and reads: …
Continue reading Updates to the SSIS Extension for Visual Studio 2019

SSIS 2019 Extension v3.10 for Visual Studio 2019 Released

The Microsoft Azure-SSIS team released version 3.10 of the SQL Server Integration Services Projects extension a couple weeks back. I missed it until today because my writing is keeping me in my SSIS 2017 VMs and, truth be told, I am a little off my game the past few weeks. Apologies for this delayed post. …
Continue reading SSIS 2019 Extension v3.10 for Visual Studio 2019 Released

Where’s the SSIS Dropdown Menu in Visual Studio 2019?

Just the other day, I was whining to communicating with friends on the Microsoft SSIS team about the SSIS dropdown menu in Visual Studio 2019, sharing “The SSIS dropdown menu is missing.” In Visual Studio 2017 (SQL Server Data Tools), the SSIS dropdown menu is prominently displayed alongside other top-level dropdown menu items: The SSIS …
Continue reading Where’s the SSIS Dropdown Menu in Visual Studio 2019?

Integration Services Extension v3.9 is Available

Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for all target server version except SSIS 2017. Release Notes: Version 3.9 (Current Version): Release Date: August 24th, 2020 Build Version: 15.0.2000.128 Tested against Visual Studio 2019 16.7 …
Continue reading Integration Services Extension v3.9 is Available