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

Integration Services Extension for VS 2019 v3.8 Released

The Integration Services v3.8 extension for VS 2019 has been released! From the SQL Server Integration Services Projects page: <ShamelessPlug> Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises kickstart or complete Enterprise Data Warehouse projects – whether on-premises or in the cloud. Our experienced engineers grok enterprises of all …
Continue reading Integration Services Extension for VS 2019 v3.8 Released

On Installing Integration Services Versions Side-by-Side

I do not recommend installing Integration Services versions side-by-side. Microsoft provides an article describing how to accomplish side-by-side installation of Integration Services, but the article has not been updated in over three years and the last SSIS version mentioned is 2016. Over the years, I have helped customers who have more than one version of …
Continue reading On Installing Integration Services Versions Side-by-Side