Hi @Stepper, Ludwig ,
Welcome to Microsoft Q&A!
For SSRS(Microsoft Reporting Services Projects), you can install it from Extensions > Manage Extensions or from the Marketplace.
For SSDT, you need to install it through Visual Studio Installer > Individual components > SQL Server Data Tools.
After installing SSDT and SSRS, please re-launch your VS2022 and create the report server project again.
For more details, please refer to: SSDT for Visual Studio 2022.
Sincerely,
Anna
*
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
sql server data tools - SSDT Installation issue on VS2022 - Stack Overflow
Visual Studio 2022 support for SS Data Tools
SSDT for SQL 2022 not available
Does visual studio 2022 community edition provide full ssdt functionality ?
Videos
I did a fresh install of windows on my main computer and went ahead and installed SQL Server 2019 Developer Edition.
I do a lot of work with SSIS and SSAS (Tabular) and assumed the Visual Studio Extension used for these modules would be available in Visual Studio 2022 Community so I went ahead in installed that too. To my suprise when I loaded it up, it did not support working on these projects only "Database Projects" not involving SSIS or SSAS. So I had to uninstall 2022 and roll back to 2019.
Any idea when VS 2022 will be supporting SQL Server Data Tools? Supposedly 2022 is much better than 2019 as its the first 64 bit version of VS.
Background: So I have the need to generate an array of JSON objects in a single column in my main select. I found that you can do this with a new feature in SQL 2022. There's a new function called JSON_OBJECT which works perfectly if you combine it with FOR JSON PATH in a subquery.
The problem is all my table structures, procs, schemas and views are in a VISUAL STUDIO database project which, when compiled, generates a nice little DACPAC file which I can then use to deploy to the database on the production server.
The production server also runs SQL Express so upgrading it is not an issue.
I installed SQL 2022 express and tried to write my new little view to generate the data in the format I need which works perfectly, but I cannot change the "Target platform" in my database project to SQL 2022, the option is simply not there. I have googled and the Microsoft docs says you cannot install SSDT seperately as of Visual studio 2019. ( I am using VS2022). It comes with visual studio when you select the SSDT feature
So now as soon as I create the view and add it to the database project I get baraged with syntax errors because the project doesnt understand the format of my new view that uses my new JSON_OBJECT function.
How can I resolve this? Is there a forum I can post this to so that the SQL engineers at Microsoft can fix this?
Hello @techresearch7777777 ,
Welcome to Microsoft Q&A forum.
After opening VS Installer, you can click Modify, choose Workloads tab, check Data storage and processing workload, on the right, you should see SQL Server Data Tools, check it too. If you still cannot find it, try to switch to Individual components tab, search SQL Server Data Tools, you won’t miss it.
How to know if SSDT is installed and if not how?
After you check the SQL Server Data Tools component in VS Installer, don’t forget to click Modify button to install it. If it has been installed, the next time you open VS Installer, you will see that it has been checked, and if you open Visual Studio, you will see related database project templates listed in the create a new project window.
I have VS 2019 installed and need to open and view SSIS dtsx packages on seeing exactly what they’re doing.
You may also need to install SSIS extension in VS 2019, please try to open VS, click Extensions, Manage Extensions, Online, search for SQL Server Integration Services Projects extension, click Download and close VS to install it.
Best Regards,
Tianyu
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Believe I'll need SSDT to do this which how do I know if this is installed and if not how?
You want to know?
Start Visual Studio and if you have the option to create a new SSIS project, then SSIS is installed, otherwise not: Install it.
Update 5 Jun. 2023 - General Availability (GA) release
Microsoft released Version 1.0 (General Availability (GA) release) of the SQL Server Integration Services extension for Visual Studio 2022.
Update 24 Nov. 2022 - Public preview released
Microsoft added a public preview of the SQL Server Integration Services Projects 2022 to the Visual Studio marketplace, which is tested against Visual Studio 2022 17.4
Read the announcement
Update 19 Sep. 2022
Microsoft Data Platform MVP Andy Leonard stated that "I communicated with the Microsoft SSIS Team. They shared they are targeting a preview of VS2022 Integration Services Extension for the end of CY22".
Update 12 Jul. 2022
Microsoft announced the support for Visual Studio 2022 via the Microsoft Analysis Services Projects 2022 extension.
Update 01 Jul. 2022
Microsoft mentioned that Visual Studio 2022 support is one of the major items they are working on, and it will be released before the end of the year.
Update 23 Jun. 2022
Microsoft released SSIS 4.0, adding support to SQL Server 2022, but still, this version does not support Visual Studio 2022.
In addition, the support of Visual Studio 2022 is added as a common issue
Update 23 Feb. 2022
Microsoft released SSIS 3.16, where the support of Visual Studio 2022 is removed from the SSIS Installer (Bug fixed).
Initial Answer - 16 Feb. 2022
Microsoft SQL Server business intelligence extensions are still unavailable for Visual Studio 2022.
Many people are still confused about the difference between SQL Server Data Tools used to create SQL databases projects and the business intelligence suite:
- SSDT, SSDT-BI confusion in backwards compatibility for different SQL version
Using Visual Studio 2022, only the SQL Server Data Tools required to create database projects are currently available. As mentioned in the official documentation:
The core SSDT functionality to create database projects has remained integral to Visual Studio. The extensions for Analysis Services, Integration Services, and Reporting Services projects are currently unavailable for Visual Studio 2022.
You can note that in the Visual Studio marketplace, only Visual Studio 2019 is mentioned:
As Microsoft support commented on 2022-02-08:
Supporting VS2022 is on our radar, but there's no exact ETA now.