Videos
I am using the MS Hosted runner image as base then adding some additional toolsets that we need. The SSIS projects is not an available workload for the packer build to include natively, I have to install it after. The issue I have is I don't want to be dependent on a single version, but would prefer to download the latest:
https://marketplace.visualstudio.com/_apis/public/gallery/publishers/SSIS/vsextensions/MicrosoftDataToolsIntegrationServices/1.3.2/vspackage
The current version seems to be 1.3.2. For the other toolsets I have added extra, I am able to find them in some package manager, repository or GitHub to grab. I cannot seem to find a way with this one. I was thinking of using vswhere.exe to get the version of VS that the system has and use that as a basis of what version to get of the SSIS projects extension.
Updated:
I reviewed their older releases:
https://ssis.gallerycdn.vsassets.io/extensions/ssis/microsoftdatatoolsintegrationservices/1.0.1/1687243002634/Microsoft.DataTools.IntegrationServices.exe
I see that, that is a blob. I cannot move up to a more higher-level:
https://ssis.gallerycdn.vsassets.io/extensions/ssis/microsoftdatatoolsintegrationservices
I get a:
<Error> <Code>BlobNotFound</Code>
<Message>The specified blob does not exist. RequestId:78e28227-c01e-004d-159f-2306f5000000 Time:2023-11-30T15:11:47.2421681Z</Message> </Error>
which makes sense since it is a container path, not the blob itself, but even in storage explorer, connecting to:
https://ssis.gallerycdn.vsassets.io/extensions
Results in a cert error, then when I switched to use the system proxy, it gets an auth error, but being that this is a public blob, I assume it is using anonymous auth at the container level.
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.
Hello Nagesh CL,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
I understand that you could not find BI projects, and you are unable to create SSIS projects.
Solution
If you are using Visual Studio 2017 with SQL Server Data Tools (SSDT) installed and cannot find Business Intelligence (BI) projects or create SQL Server Integration Services (SSIS) projects, putting together below are some steps you can follow to resolve the issue:
- Even if SSDT is installed, you might still need to install the specific SSIS extension.
- Ensure that SSDT is installed correctly. You can do this by going to
Tools>Extensions and Updates>Installedand checking if SSDT is listed there. - Open Visual Studio 2017.
- Go to Tools > Extensions and Updates.
- Click on Online on the left pane.
- Search for "SQL Server Integration Services Projects".
- Click Download and install the extension.
- Restart Visual Studio after the installation is complete.
- Make sure Visual Studio and all its components are up to date. Go to
Tools>Extensions and Updates>Updatesto see if there are any updates available for SSDT or other related tools. - If the above steps do not resolve the issue, you may need to repair your Visual Studio installation. This can fix any corrupted or missing components. To do this:
- Open
Control Panel. - Go to
Programs and Features. - Find
Microsoft Visual Studio 2017in the list. - Click
Change. - Select
Repairand follow the on-screen instructions.
- Open
- Lasty, if you suspect that SSDT was not installed correctly, you can manually install it:
- Download the latest SSDT installer from the Microsoft website.
- Run the installer and follow the instructions to install SSDT with the SSIS, SSRS, and SSAS components.
After the above you should be able to resolve the issue and create SSIS projects in Visual Studio 2017 with SSDT installed.
References
Kindly use the links below for more reading and similar cases and more details steps to solve the above issue.
Source: Microsoft Documentation: Update Visual Studio. Accessed, 6/24/2024.
Source: SQL Server Integration Services Projects. Accessed, 6/24/2024.
Source: Install SQL Server Data Tools (SSDT). Accessed, 6/24/2024.
Source: Stack Overflow Discussion: Cannot Find SSIS in Visual Studio 2017 Accessed, 6/24/2024.
Source: YouTube Tutorial: How to Create SSIS Package in Visual Studio 2017. Accessed, 6/24/2024.
Source: Microsoft Documentation: Repair Visual Studio. Accessed, 6/24/2024.
Accept Answer
I hope this is helpful! Do not hesitate to let me know if you have any other questions.
** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.
Best Regards,
Sina Salam
Hi @Nagesh CL
To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer.
The installer lists available Visual Studio instances to add SSDT tools. If Visual Studio isn't already installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience, we recommend using SSDT with the latest version of Visual Studio.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.