SSIS Extension for Visual Studio 2022 [closed]

P

3

49

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:

Packing answered 15/2, 2022 at 12:52 Comment(0)

U

87

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:

Uzia answered 15/2, 2022 at 14:53 Comment(3)

Check also this marketplace.visualstudio.com/… – Riedel 28/11, 2022 at 12:59

seems like it still doesn't support arm64 :\ – Mortimer 26/8, 2023 at 13:12

Can the answer here be cleaned up to remove all the no-longer relevant information? It's hard to read and discern which bits, if any, are useful. Old information should be removed entirely from the post when superseding updates are made, to keep the post clean and clear. That old information is always visible in the revision history page. – Prompt 13/11, 2023 at 14:22

A

7

As Microsoft support commented on 2022-02-08:

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

Affinitive answered 16/2, 2022 at 14:3 Comment(0)

S

3

As per the link June/22/22:

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#qna

VS2022 support for SSIS is before the end of this year.

Substructure answered 1/7, 2022 at 9:3 Comment(0)