Visual Studio 2022 - No SSIS/SSAS/SSRS extensions! – SQLServerCentral Forums (2024)

More actions

November 10, 2021 at 12:26 pm

#3949867

After downloading VS2019 last week for a new project developing against SQL 2019, my colleague has come to download VS2019 today to find that Microsoft have released VS2022 and there appears to be no choice or option to download the previous version. No problem - surely, it all just work still won't it? Except NO! There are no SSRS/SSIS/SSAS extension available in the VS2022, so much so that MS have raised a support ticket where "we hope to have the extensions available in an update soon"! WTF! Where is the acknowledgement of these short coming on the VS pages and the options to download VS2019.

More actions

November 10, 2021 at 12:51 pm

#3949874

Not much consolation, but it's always been like that: VS comes out first, followed, often many months later, by the SS*S development toolset.

I suggest you revert to VS2019 for now, if you can.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

More actions

November 10, 2021 at 3:41 pm

#3949980

Honestly, I doubt you'll see the extension until after SQL Server 2022 starts hitting public preview, or even not till after it's released. The SSIS extension for Visual Studio 2019 was still in Preview when SQL Server 2019 was released, if I recall correctly (and it was the only version that supported SQL Server 2019).

More actions

December 2, 2021 at 10:16 am

#3959479

More actions

December 2, 2021 at 10:52 am

#3959497

you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/

More actions

December 2, 2021 at 10:54 am

#3959499

Why are you forced to not also download Visual Studio 2019? You can have multiple editions of Visual Studio installed. My work PC has both VS 2015 Professional and VS 2019 Community installed. And at home on my Windows 11 VM I have both VS 2019 and VS2022 Community installed. VS 2019, on both machines, is for the SSIS and SSRS extensions.

More actions

December 2, 2021 at 10:59 am

#3959500

I must admit, it really annoyed me how much they hid the old installs away; took me ages to find the installer for VS 2019 the other week. I wouldn't mind, if it was a case of license for prior versions were transferable, and that VS 2022 fully supported everything from 2019. It doesn't and so hiding the prior versions away it just really poor UX/UI.

More actions

December 23, 2021 at 1:08 pm

#3966688

As I mentioned in my post the links are there but unless you have an active subscription you cannot download it.

You can still download VS2022 , but as the original post is pointing out, the SSIS functionality I am looking for does not work in the latest version.

Above you can see what you are greeted with if you are trying to download VS2019.

More actions

December 23, 2021 at 2:51 pm

#3966742

Seems that they've put it behind a sign-in wall now, but you do not need an active subscription. If it helps, however, you can go to this URL (which I got after signing into my account) and you can download VS-2019 Community from it (no sign in required).

More actions

December 24, 2021 at 9:47 am

#3966964

Thanks Thom for the link and support.

This was all I needed , and I can perhaps understand that Microsoft want to push us to use the new tooling, but when the core tools used for some of its core products does not work / exist yet , there should be some alternative options available.

Happy holidays and hopefully a better 2022 for you and your family.

• This reply was modified 2 years, 6 months ago by Snakeyes.

More actions

December 24, 2021 at 9:52 am

#3966967

I will admit, it "smells" a little like the left hand not talking to the right hand. I wonder if they would accept a PR on the documentation that links directly to the above page, as I suspect that many people are going to be stumped by the the lack of an obvious way to get to the download.

More actions

April 14, 2022 at 9:38 pm

#4016390

SSDT apparently now available for VS 2022...

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

More actions

April 15, 2022 at 8:53 am

#4016619

This thread is about the SSIS/SSAS/SSRS extensions for VS 2022, not SSDT itself. Those extensions do not yet seem to be available. Eg, for SSAS, check this link and you will see the following:

Works with

Visual Studio 2017, 2019

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

More actions

April 15, 2022 at 10:57 am

#4016656

SSDT was available since the launch of VS 2022; the SSAS, SSIS and SSRS extensions are not. Since 2016 (iirc) SSDT has simply meant the database project side of things; nothing more.

More actions

April 19, 2022 at 2:55 pm

#4018673

Correction, SSRS for VS2022 is available. There is no VS 2022 release (yet) for SSIS and SSAS; you need to continue to use VS 2019 (which SSRS is also available for).