question

Dudarino avatar image
Dudarino asked

What happened to SSRS and SSIS in Visual Studio 2019?

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.

ssisssrsvisualstudio
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dudarino avatar image
Dudarino answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

0 Likes 0 ·
anthony.green avatar image
anthony.green answered

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.MicrosoftReportProjectsforVisualStudio

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.