I have installed SQL Server Data Tools but it only seems to be good for editing sql statements. How are we supposed to maintain reports or legacy SSIS code?
I found an install example that shows adding Extensions to VS 2017 but that is not an option in VS2019.
I managed to find SSIS. Apparently you have to start a new project with no code. Click on Extensions and then install SSIS. How confusing is that? I am still finding posts that say it is not included in VS 2019 or that it is somewhere in the install process that there are options to select that I have not found yet.
It has always been a bit confusing to me because the naming has changed between versions. Used to be SSDT, then SSDT BI, then SSDT again and then extensions for each project type. I like the way it's done now, that Integration Services has their own extension that can be easily downloaded. You don't need to create empty project to download extensions.
The extensions can be installed from within VS for SSRS and SSAS via the extensions menu option.
SSIS needs a seperate install.
Below are the links for the exe's / vix files if you want to download outside of VS
https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects
https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
19 People are following this question.
