'SSIS Extension for Visual Studio 2022

I have downloaded and installed Visual Studio 2022. Then after click on modify

to add SSDT

here you can see

Now, I want to create SSIS package, for this I have started VS22 and in "manage extensions" when I try to find Microsoft SSIS, I am unable to find.

For this, I have downloaded SSIS from market place:

but when I try to install this it throws below error:

enter image description here

sql-serverssisetlsql-server-data-toolsvisual-studio-2022


Solution 1:[1]

As @Larnu commented, Microsoft SQL Server business intelligence extensions are still not available 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:

Using Visual Studio 2022, currently only the SQL Server Data Tools required to create database projects are 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 not available for Visual Studio 2022 at this time.

You can note that in the Visual Studio marketplace only Visual Studio 2019 is mentioned:

enter image description here

Solution 2:[2]

As Microsoft support commented on 2022-02-08:

Supporting VS2022 is on our radar, but there's no exact ETA now.

Solution 3:[3]

Update for VS 2022 version 17.1.0 was released. SSRS for VS 2022 was released as well, but SSIS is still not available or I cannot find it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Hadi
Solution 3 user18377762

Related Questions