No Integration Service Project For VS 2022

balu raju 56 Reputation points
2022-06-03T14:24:33.757+00:00

I see the following for VS 2019
For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.

Analysis Services
Integration Services
Reporting Services

But I only see the following for VS 2022
For Analysis Services or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.

Analysis Services
Reporting Services
The extension for Integration Services projects is not available for Visual Studio 2022 at this time.

Does this mean I have to use VS 2019 for integration project?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 26,586 Reputation points
    2022-06-03T16:03:01.267+00:00

    Hi @balu raju ,

    That's correct. Just stay with the VS2019 for now.
    The VS2022 Integration Services Projects extension is not available yet.

    It is officially documented here: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

    I received the following response while contacting Microsoft folks directly:

    The product group confirmed that unfortunately they don’t have an ETA at the moment on releasing SSIS projects for VS 2022 since VS 2022 is the first one to only run in 64 bit, they need to spend some considerate time to develop the SSIS project extension for it.

    3 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Andrew Kagan 6 Reputation points
    2022-07-18T12:13:07.697+00:00

    Even though there's no support for Integration Services projects yet, we're getting this alert when opening VS2022:

    221808-image.png

    Someone may not realize that they need IS support and uninstall 2019 by mistake.

    1 person found this answer helpful.

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.