Share via
sql dev 6Reputation points
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,539 questions
Sign in to follow
1{count} vote
Philippe Levesque 5,716Reputation 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 6Reputation 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: - I have checked and the Project does exist at the location. The version of visual studio is 2019
Sign in to comment
3 answers
Sort by: Most helpful
Michael Taylor 52,236Reputation 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.
sql dev 6Reputation 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 52,236Reputation 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.jIf 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 6Reputation 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 52,236Reputation 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,711Reputation 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.
sql dev 6Reputation 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,711Reputation 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 6Reputation 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 6Reputation 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 52,236Reputation 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 1Reputation point
2022-12-14T11:17:48.657+00:00 reload after installing extension helped
Sign in to comment
sql dev 6Reputation 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 commentsNo comments
Sign in to comment
Sign in to answer