Visual Studio 2022 - No SSIS/SSAS/SSRS extensions!
-
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.
-
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
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).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
So here I am with a new laptop, forced to download the latest version that does not support one of the core functions I perform at my work.... I can see that this forces me to have an active license to be able to download the older software so that I can do my job. Seems like a solid business model.
-
you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/
- Snakeyes wrote:
So here I am with a new laptop, forced to download the latest version that does not support one of the core functions I perform at my work.... I can see that this forces me to have an active license to be able to download the older software so that I can do my job. Seems like a solid business model.
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - frederico_fonseca wrote:
you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
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.
- Snakeyes wrote:
As I mentioned in my post the links are there but unless you have an active subscription you cannot download it.
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).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
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.
-
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
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
- kblum wrote:
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
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
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin - kblum wrote:
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
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
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).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply