SSIS Extension for Visual Studio 2022

Viewed 48443

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

4 Answers

Update 2022-07-01

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.

enter image description here


Update 2022-06-23

Microsoft released SSIS 4.0 adding support to SQL Server 2022, but still, this version does not support Visual Studio 2022.

enter image description here

In addition, the support of Visual Studio 2022 is added as a common issue

enter image description here


Update 2022-02-23

Microsoft released SSIS 3.16 where the support of Visual Studio 2022 is removed from the SSIS Installer (Bug fixed).

enter image description here


Initial Answer

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

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.

Related