Share via

Has Microsoft abandoned SSIS projects in Visual Studio 2022?

Dimmick, Jason, PED 0 Reputation points
2023-03-03T12:30:24.5966667+00:00

I installed Visual Studio 2022 and can no longer view the dtsx files in my SSIS project.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Microsoft Teams | Development
SQL Server | Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 26,586 Reputation points
    2023-03-03T15:20:55.9+00:00

    Hi @Dimmick, Jason, PED,

    As Dan Guzman already pointed out, Microsoft has a preview of the SQL Server Integration Services Projects extension for VS2022: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

    It supports a limited number of the SSIS run-time: 2017 and later.

    So, no SSIS run-time support for 2012, 2014, and 2016.

    It is a big release because for the very first time extensions for VS2022 shall be in 64-bit mode to match the VS2022 itself.

    I would suggest waiting for its GA release, and in the meantime keep using VS2019 and its SSIS extension.

    0 comments
  2. ZoeHui-MSFT 41,496 Reputation points
    2023-03-06T06:53:33.6266667+00:00

    Hi @Dimmick, Jason, PED,

    You may need to install SSIS2022 in VS first, from the here or click on "Extensions" > "Manage Extensions", SQL Server Integration Services Projects" and press "Download" in VS.

    Like @Yitzhak Khabinsky said, VS2022 do not have the GA release, you may keep using VS2019 and its SSIS extension.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.