Incompatable error

sql dev 6

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.

Philippe Levesque 5,711 Reputation points

2022-03-16T16:37:17.317+00:00

Hi, please edit to add the Migration Report, so we can help to find what cause the error. Thanks
sql dev 6 Reputation points

2022-03-17T10:08:08.493+00:00

From the Migration Report, the following is the error message .dtproj: The application which this project type is based on was not found. Please try this link for further information: https://go.microsoft.com/fwlink/?LinkId=660952&projecttype=159641D6-6404-4A2A-AE62-294DE0FE8301 - I have checked and the Project does exist at the location. The version of visual studio is 2019

3 answers

Michael Taylor 51,346 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.
Please sign in to rate this answer.

1 person found this answer helpful.
sql dev 6 Reputation points

2022-03-17T10:13:54.783+00:00

The version of visual studio, ssis package is the same and SQL Server Integration Service Project extension are all 2019 has been installed, is there another extension which is required? or if there anything else I should be looked out for?

Michael Taylor 51,346 Reputation points

2022-03-17T14:33:01.34+00:00

If you triggered a migration then it sounds to me like you were on an older version of VS when you originally created the SSIS package. Nevertheless if you right click the project in Solution Explorer and select Load Project does it load now? I'm wondering if you didn't have the necessary components installed when you loaded the solution initially so the migration (which is a one time thing) failed but you can load the project now.j

If it still doesn't load then open the .dtproj in a text editor and post the values for the following fields/properties:

ProductVersion

SchemaVersion

SSIS:Property FormatVersion

SSIS:Property PackageFormatVersion

TargetServerVersion

sql dev 6 Reputation points

2022-03-18T10:43:49.097+00:00

When trying to load the project, I get the same issue as before.

Here are the values for the fields/properties:
<ProductVersion>15.0.2000.180</ProductVersion>
<SchemaVersion>9.0.1.0</SchemaVersion>
<SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
<SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
<TargetServerVersion>SQLServer2019</TargetServerVersion>

Thank you!

Michael Taylor 51,346 Reputation points

2022-03-18T16:09:47.937+00:00

Those seem up to date. Can you also post a screenshot of the Help\About where it is showing your versions of SSDT and SQL Server Integration Services extensions? Could be a mismatch there. Note that SSDT is installed when you selected the Data storage and processing workload in the VS installer.
Sign in to comment
ZoeHui-MSFT 35,556 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.
Please sign in to rate this answer.
sql dev 6 Reputation points

2022-03-17T10:15:05.94+00:00

The SSIS Package is used in Visual Studio. The version of visual studio, ssis package is the same and SQL Server Integration Service Project extension are all 2019 has been installed, is there another extension which is required? or if there anything else I should be looked out for?

ZoeHui-MSFT 35,556 Reputation points

2022-03-18T02:03:24.847+00:00

Hi @sql dev ,
Please check that if you have installed the latest version of SSIS project and make sure in is enabled in VS.
https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview
And then open your project. It will complain. Just ignore it.
Right mouse click on top of the SSIS project in the Solution Explorer and select Reload Project entry.

sql dev 6 Reputation points

2022-03-18T10:47:39.437+00:00

Thank you for your reply,

The Extension: the SQL Server Integration Services Project has already been installed

Here are the values for the fields/properties of the ssis package:
<ProductVersion>15.0.2000.180</ProductVersion>
<SchemaVersion>9.0.1.0</SchemaVersion>
<SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
<SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
<TargetServerVersion>SQLServer2019</TargetServerVersion>

sql dev 6 Reputation points

2022-03-25T11:17:04.18+00:00

Hi @ZoeHui-MSFT reloading the file doesn't seem to work too - hopefully the information provided is clear or there anything else I should be checking?

Michael Taylor 51,346 Reputation points

2022-03-25T13:47:55.34+00:00

Can you post the entire .dtproj or make it available via download. The related packages and other files aren't needed. If we can load the project file in our version of VS then it would seem to indicate a problem with the packages and not the project. At that point I would recommend that you modify the project file and remove all the packages/data source files. Then attempt to load the project. If it loads then add back in the packages/data sources one at a time until you're done. My gut instinct is that one of them may have a reference to something in SSIS or elsewhere that isn't installed/supported in the newer VS version.

Jakub Skibicki 1 Reputation point

2022-12-14T11:17:48.657+00:00

reload after installing extension helped
Sign in to comment
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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

Incompatable error

3 answers