Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

visual studio 2019 open solution file incompatible

I think I was using visual studio 2017 and wrote a SSIS package. Now I installed visual studio 2019 and can't open the solution file. Error:

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. - ABC, "C:\Users\XYZ\ABC.dtproj"

Non-functional changes required Visual Studio will automatically make non-functional changes to the following projects in order to enable them to open in Visual Studio 2015, Visual Studio 2013, Visual Studio 2012, and Visual Studio 2010 SP1. Project behavior will not be impacted. - ABC_SSIS, "C:\Users\XYZ\ABC_SSIS.sln"

I tried "Right-click on the project and reload" - didn't work.

I tried to confirm SSDT is installed: it is installed at the installation interface, but doesn't exist in extension manager: installed SSDT

no SSDT in extension manager

like image 687
YJZ Avatar asked Sep 12 '19 20:09

YJZ


People also ask

How do you resolve an incompatible issue in Visual Studio?

Goto Tools > Extensions and updates > and search for integration/analysis/reporting (delete as applicable) and [enable] or [disable and then re-enable], close and restart VS. When you restart the projects will still show as incompatible, but right click and reload project seems to do the trick on each one.

How do I open a DTS file in Visual Studio 2019?

Within the project (solution explorer) you can open the dtsx. Do not try to open the dtsx file from the source control explorer as that does not open with the project references. In summary, open the solution/project, then open the package from the solution explorer.

How do I open an existing SSIS package in Visual Studio 2019?

In Visual Studio, click New > Project on the File menu. In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services. Select Integration Services Import Project Wizard from the project types list.

Why is my project incompatible with the current version of Visual Studio?

If the message This project is incompatible with the current version of Visual Studio is due to an attempt to open a project targeting.Net 4.5, then the "solution" or workaround is to edit the.csproj file and change the TargetFrameworkVersion from "v4.5" to "v4.0".

Why can't I open SSIs project in Visual Studio 2019?

Please make sure that you have latest versions of both VS2019 and SQL Server Integration Services Projects extension installed. How to remedy the situation: Try to open VS 2019 solution with SSIS project. It will complain. Just ignore it. Right mouse click on top of the SSIS project in the Solution Explorer and select Reload Projectentry.

How to fix Microsoft integration services projects not working in Visual Studio?

I just used Tools --> Extensions and updates, look for the disable extension (Microsoft Integration Services Projects) and enable it again, after that close and reopen visual studio, go to Solution explorer right click on your solution and select Resolve errors, that fixed the issue for me.

Does Visual Studio 2019 support all types of net?

Among the workloads and project types, you can find support for .NET Framework, .NET Core, Mono, .NET Native for Universal Windows Platform (UWP), C#, F#, and Visual Basic. Visual Studio 2019 supports the following .NET implementations:


4 Answers

SSIS is a seperate extension now in Visual Studio 2019. You can install that extension in Visual Studio market place. Choose Online tab and search for "SQL Server Integration Services Projects".Hope it can help your problem

like image 102
Xuan An Nguyen Avatar answered Oct 19 '22 05:10

Xuan An Nguyen


  • 1.Extensions -> Microsoft Reporting Service Project
  • 2.and then close visual studio
  • 3.VSIX installer will complete automatically
  • 4.If your project unloaded, right click on project and reload
like image 29
Akçay Şahin Avatar answered Oct 19 '22 03:10

Akçay Şahin


Today I faced this issue,

Cause

The reason for issue is, I saw a yellow bg notification at the top of IDE showing performance issue screenshot included, with option to "disable this" to improve the performance. I chose disable, later next day when I opened the project, It showed the project is not compatible. I did Repair SSIS, Uninstall and Reinstall SSIS, and also updated the SSIS to latest version. None of these 3 ways resolved the issue.

Solution

But, I found Manage Extension submenu item under Extension menu, Under installed tab, SSIS extension was in disabled status. I reverted to Enabled status. Sample screenshot of the same for reference is here. If it disabled, simply enable it. Then restart VS with SSIS project. enter image description here

like image 25
Pranesh Janarthanan Avatar answered Oct 19 '22 03:10

Pranesh Janarthanan


Enabling the SSIS in manage extensions solved this for me.

enter image description here

like image 1
Kumar Palle Avatar answered Oct 19 '22 03:10

Kumar Palle