Unsupported This version of Visual Studio is unable to open the following projects

Question

I'm getting error like this after updating sql server to 2016. I have opened the project in VS2015 & while rebuilding Database project I'm getting error like below:

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.

Since I didn't upgrade to 2016 by now I am not sure, but maybe you have to do some additional installation? Such as Data Tools 2016 or something? By the way, in which VS did you create the project initially? — Tyron78, Aug 10 '17 at 12:06
Install Sql Server Data Tools. Similar question to this: https://stackoverflow.com/questions/18148445/cannot-open-sqlproj-because-it-is-not-supported — Carra, Aug 10 '17 at 12:08
@Tyron78 I have created project in vs 2015 and currently using same — Averla Team, Aug 10 '17 at 12:13
Then it is most certainly that you need to install / update the SQL Server Data Tools - they are dependent on the SQL Server Version — Tyron78, Aug 10 '17 at 12:24

Refael · Answer 1 · 2021-07-19T12:50:53.173

30

I got the same error when opening Old (VS2015) project on Visual Studio 2017

These actions solved my problem:

Install the latest version of SSDT
Open Visual Studio 2017: Go to: Tools > Extensions And Updates > Search: Microsoft Integration Services Projects > Click: Enable
In SSIS Project On Solution: Right Click > Reload Project

edited Jul 19 '21 at 12:50

answered Aug 12 '18 at 14:18

Refael

6,753
9
35
54

1

Are you still able to open the project with VS2015 after successfully opening in VS2017, or does it convert the project? Some on our team haven't upgraded yet. – Brien Malone Sep 30 '19 at 21:08
1

just adding that this solution also work for studio 2019 – Stefanos Zilellis Apr 07 '21 at 11:15
3

@StefanosZilellis I can't find `Microsoft Integration Services Projects` in Extensions --> Manage Extensions in VS2019. – xinthose May 03 '21 at 17:44
1

@xinthose not sure why, try the text search perhaps? – Stefanos Zilellis May 24 '21 at 14:06
If anyone wondering its called _SQL Server Data Tools - Sql Editor_ in VS 2022. At least that's what I had to enable. Thanks for the tip. – nawfal Oct 07 '22 at 13:30
It isn't working in my case. I tried install and enable it from Extensions but doesn't work. – Bansi Ardeshana Jan 20 '23 at 06:30

score 5 · Answer 2 · edited May 06 '20 at 21:15

5

I got the same error when opening old projects in Visual Studio 2019.

These actions solved my problem:

Open Visual Studio 2019 and go to Tools > Extensions > Download to download these three tools:

SQL Server Integration Services Project
Microsoft reporting service project
Microsoft analysis service project

Close VS and update package, then restart VS by double-click an old .sln file.

edited May 06 '20 at 21:15

Adrian Mole

49,934
160
51
83

answered May 06 '20 at 18:22

All I had to enable was _SQL Server Data Tools - Sql Editor_ in VS 2022. – nawfal Oct 07 '22 at 13:31
It isn't working in my case. I tried install and enable it from Extensions but doesn't work. – Bansi Ardeshana Jan 20 '23 at 06:31

score -4 · Answer 3 · answered Mar 22 '19 at 03:48

Uninstall all SQL Data Tools from Programs and Features
Uninstall Analysis Services and Reporting Services
Install SSDT for Visual Studio from Microsoft website
Right click Visual Studio solution file and 'Open With' MS Visual Studio 2017
Right click and choose 'Reload Project'

Unsupported This version of Visual Studio is unable to open the following projects

3 Answers3

Linked