Incompatable error

sql dev 6 Reputation points
2022-03-16T15:56:41.66+00:00

Is there any resolution for the following message although all the required extensions have been installed and the projects are compatible to the version please?

Unsupported
This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them.
For more information on enabling these project types or otherwise migrating your assets, please see the details in the "Migration Report" displayed after clicking OK.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
{count} vote

3 answers

Sort by: Most helpful
  1. Michael Taylor 49,246 Reputation points
    2022-03-16T17:52:43.257+00:00

    What version of SSIS is your packages? What version of Visual Studio are you using? What extension did you install and what version is it?

    SSIS is tied closely to the version of SQL and older packages won't work with newer SSIS extensions if they dropped support. Refer to the supported versions document.

    Also be aware that SSDT is now broken up and partially supported in VS 2019/2022 and partially through extensions. SSIS packages can only be opened using the SQL Server Integration Services extension which must be installed separately. This extension is not yet supported by VS 2022 so you'll need to stick with VS 2019 if you're using it.


  2. ZoeHui-MSFT 33,626 Reputation points
    2022-03-17T06:31:15.58+00:00

    Hi @sql dev ,

    May I know what's your version of the Visual Studio?

    Are you opening a SSIS project?

    Make sure that you have installed the SQL Server Integration Services Projects.

    You can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.

    Please note that there's no SSDT standalone installer for Visual Studio 2022.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. sql dev 6 Reputation points
    2022-03-31T09:50:23.833+00:00

    Performing the following seem to have fixed the issue:

    Go to Control Panel -> Programs -> Programs and Features

    Find Microsoft Visual Studio Installer in the list of programs installed on your PC/Laptop.

    Right Click on this line and click 'Change'. This will open the Installer, and you should see two products in the Installed section - Microsoft SQL Server Data Tools and Microsoft Visual Studio.

    Under Microsoft SQL Server Data Tools -> Click on 'More' and select 'Repair' option.

    0 comments No comments