Public preview of SQL Server 2022 Integration Services

[Chunhua]

SQL Server 2022 announced public preview, Integration Services for SQL 2022 is also available. 

Visual Studio SQL Server Integration Serivces extension 4.0 (Preview) is available, new features and improvements included are: 

• Support SQL Server 2022 as target server
• Fixed ODBC incorrect binding when output column sequence is different from external column sequence

Details refer to SQL Server Integration Services Projects - Visual Studio Marketplace

SQL Servier Management Studio (SSMS) 19 (Preview) is also available, details refer to 

• Release notes: Release notes for (SSMS) 19 (Preview) - SQL Server Management Studio (SSMS)
• Download: Download SQL Server Management Studio (SSMS) 19 - SQL Server Management Studio (SSMS)

[seanholm]

This "Visual Studio SQL Server Integration Services extension 4.0 (Preview)" does not work with Visual Studio 2022.

Is SSIS project support in VS2022 being delayed until SQL2022 has been officially released? 

Why not just update the existing extension so that it works in VS2022 for SQL2019 (& earlier) versions?  This way we can at least use the new IDE for our existing SSIS projects and current SQL targets.

SSIS project support for SQL2022 will eventually arrive - but when? Please give us an ETA!! 

[Chunhua]

@seanholm Product group is working on SSIS for VS 2022, current outlook is end of this year.   

[Richard333]

So when VS2023 comes out and the story starts all over again.

It is absurd that SSIS is more than a year behind the release of a new Visual Studio.

It was already always behind but not a year...

[RetoKummer]

@Richard333 So far, VS didnt have a yearly release schedule - and SSIS (Extensions) for VS have always been released after release of the corresponding SQL Server Integration Services. As SQL Server 2022 not even is a full release yet, expecting the corresponding SSIS to be out yet is what is absurd.

[Richard3333]

@RetoKummer SQL Server 2022 has nothing to do with it. SSRS 2022 was already released in March and SSAS was released this month, both before the release of SQL Server 2022. 

The current SSIS extension in VS 2019 supports older SQL Server versions and so will the SSIS extension for VS 2022. No need to wait for a corresponding release of SQL Server. 

Microsoft could at least release a SSIS extension that supports all current SQL Server versions and update the extension later when SS 2022 is released.

If they did this from the start with all of their own extensions then everyone could use the latest VS 2022. Microsoft doesn't even mention the lack of support for these extensions when you download VS 2022. And they made it also pretty hard to find the downloads of older versions of VS.

You may find the wait of a year acceptable, I don't and based on the many posts over the years about the delayed release of this extension, almost none of the SSIS users do.

[David_Lean]

Clearly those working on the VS SSIS Extension have a lot of other development priorities. 
However it is in Microsoft's best interests to have their community rapidly adopt the latest releases of their product. That is a core part of the value proposition of the Visual Studio Subscription. Often you must be on the latest released to take advantage of the latest Azure Technologies. 

SQL Server is a core part of the Microsoft offering. The lag in the release of critical extensions like SSIS & Reporting is a roadblock to an entire enterprise upgrading to the latest version of Visual Studio. No-one wants to maintain two different versions of a development tool thru the org. It creates confusion & bugs. 

Unless the VS release had some major breaking change. You'd think someone senior in Microsoft would ensure sufficient focus was given to ensure backward compatibility of these extensions. so that they could be available close to the release of a new version of Visual Studio. 

[stuart-jarden]

Hi, I tried to install it on Visual Studio 2019 Professional, but it asks me to close PerfWatson2, which I can't figure out how to do.

[Chunhua]

@stuart-jarden it is a process of Visual Studio, takes a while to exit after close VS. You can try How to disable Perfwatson2.exe from Visual Studio - Stack Overflow

[IcemanSven]

Visual Studio SQL Server Integration Services extension is currently down. Any info when it will be available again?