'Error while opening SSIS package in Visual Studio (Incompatible)
Quite new to SSIS. To open existing SSIS packages in Visual Studio and I clicked SSIS but it has opened Visual-Studio and not my packages.
In solution explorer showing that SSIS packages(incompatible) and below that "the application not installed",but actually in Extensions windows its showing that installed SSIS. Please help me out resolve the below error (Image). I tried to modify the package and uninstalled the SSIS tool and installed again. But still same problem
Solution 1:[1]
I had the same problem and I found this menue choice in Visual Studio. I right clicked the Solution, chose Resolve Errors and it resolved my problem.
Solution 2:[2]
I think you need to install SQL Server Data Tools for you to launch the project and test in your local SQL instance. If you're, like me, fairly new to SSIS package, I suggest you follow this Microsoft official tutorial so that you are familiar with ins and outs of SSIS package.
If you are sure that you have installed all necessary components, please ensure that VS > Tools > Extensions and Updates > Microsoft Integration Services Projects is enabled. Once enabled, restart Visual Studio. It might still look the same. Last step is to right-click on the project and choose "Reload Project".
Solution 3:[3]
I always ignore and shut down the carking update notification when opening SSIS, until I encountered this error.
I tried googling it and tried "reload project" and "Resolve errors" option, I also uninstalled SSDT and reinstall it, I also disabled and enabled SSIS in "Extensions and Updates" Bar. They all failed.
So I updated SSIS since I'm bored and tired, then I tried "reload project" and "Resolve errors" option again, the magic is everything going fine, like before! It's just my experience, not representative.
Solution 4:[4]
I already faced the same problem, for some reasons the SSIS extension was disabled.
So to resolve this issue you need to go to :
Extensions > Manage Extensions > Installed
Make sure that the SSIS extension is enabled then close and reopen you project.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Glenn Gordon |
| Solution 2 | |
| Solution 3 | user618520 |
| Solution 4 | Abdelhak |