SSIS Extension for Visual Studio 2022

Question

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

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:

• SQL Server Integration Services Projects

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

Solution 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:

• SSDT, SSDT-BI confusion in backwards compatibility for different SQL version

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:

Solution 2

As Microsoft support commented on 2022-02-08:

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

Comments

[Larnu]

From the documentation: "The extensions for Analysis Services, Integration Services, and Reporting Services projects are not available for Visual Studio 2022 at this time." Emphases mine. Use 2019 for SSIS, SSAS and SSRS.

[Joey Morgan]

I had SSIS in 2019 and even had an Integration Services Project in my current solution, and suddenly it is unrecognized and unavailable. What gives?