Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Public preview of SQL Server 2022 Integration Services

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Jun 02, 2022

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 

 

Updated Jun 02, 2022
Version 1.0
  • seanholm's avatar
    seanholm
    Copper Contributor

    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!! 

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

  • Richard3333's avatar
    Richard3333
    Copper Contributor

    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.

  • Richard333's avatar
    Richard333
    Copper Contributor

    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...

  • David_Lean's avatar
    David_Lean
    Copper Contributor

    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. 

  • RetoKummer's avatar
    RetoKummer
    Copper Contributor

    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.

  • stuart-jarden's avatar
    stuart-jarden
    Copper Contributor

    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.

  • IcemanSven's avatar
    IcemanSven
    Copper Contributor

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