Unable to open SSIS projects in VS2019

Question

Hi:

I was working with a SSIS project in VS2019. Everything was fine. There was a notification to the effect that an extension related SSIS support for SQL server may be slowing the system and asked me whether I should disable the extension. I did that and it said that the change will take effect after re-starting VS2019.

When I restarted and tried to open the Solution that was fine, I see "(incompatible)" next to the Project file and under that it says the application may not have been installed!

I went back and reactivated the SQL Server Integration Services Projects extension (Now it says disable/uninstall). But I still cannot open the solution.

Please advise.

Venki

Answer 1

I experienced the same in the past.

Please make sure that you have latest versions of both VS2019 and SQL Server Integration Services Projects extension installed.

How to remedy the situation:

1. Try to open VS 2019 solution with SSIS project. It will complain. Just ignore it.
2. Right mouse click on top of the SSIS project in the Solution Explorer and select Reload Project entry.

Answer 2

I had the same exp. Mine was working before and the next day, I wasn't able to open any project.. when I go to Manage Extension>Installed>SQL Server Integration Services Projects, turns out it was disabled.. so I just click enable again and then restart visual studio. and it's working again!

Answer 3

Hi @Venkat Venkataramanan ,

I went back and reactivated the SQL Server Integration Services Projects extension (Now it says disable/uninstall). But I still cannot open the solution.

May I know if you can share the error messages when you meet this situation?

Please try to uninstall the Visual Studio 2019 and then install the VS 2019 again.

Hope the following link will be helpful:
Install SQL Server Integration Services in Visual Studio 2019

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 4

Yitzhak:

Thank You! You saved my day!

Venki

Answer 5

Mona:

Yitzhak was able to solve the issue and thank God I did not have to go through the whole uninstall/re-install routine!

But since you work for Microsoft, it will be wonderful if you can investigate why such things happen.

Venki