Installing SSDT for Visual Studio 2017

I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it. I also have SSDT for VS 2015 installed, as an add-on in Visual Studio 2015 Enterprise (because that’s the only way to get TFS working in VS 2015). I tried to re-install SSDT 2017 (stand-alone or integrated into Visual Studio), but every time it crashed. Someone on the SSDT team told me there were some issues with the internal build numbers, but a fix would be coming soon.

So today I tried again with the latest version of SSDT. On the first attempt, the installer crashed again with the error message “the requested metafile operation is not supported”. I contacted the SSDT team again and they told me to reboot my machine and try again (no seriously, they did).

Anyway, when I launched the installer again after the reboot, it seemed the stand-alone SSDT shell was already installed and I just had to add SSIS/SSRS/SSAS. The installer gave same weird error about needing to close devenv (while nothing was open at the time), but I ignored the error and continued with the set-up. And lo and behold, SSDT 2017 was installed just fine. So sometimes a reboot really does work.

When opening VS 2017 for the first time, I was greeted with the following strange messages:

And team explorer:

And when I tried to close everything:

Weird stuff. But a reboot of Visual Studio fixed it again (yes, there’s a theme!). Everything seems to work fine and even the source control integration works, so I’m pleased to announce it’s safe to use SSDT 2017 (at least, when you have rebooted 😉


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

Recent Posts

Get row counts of all tables in a Microsoft Fabric warehouse

I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You…

4 days ago

dataMinds Saturday 2024 – Session Materials

It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of…

7 days ago

Check your regions people

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came…

3 weeks ago

Book Review – Deciphering Data Architectures

I recently purchased and read the book Deciphering Data Architectures - Choosing Between a Modern…

4 weeks ago

Fabulous Stuff in Fabric – Part 5: Folders in Workspaces

A while ago I had a little blog post series about cool stuff in Snowflake. I’m…

1 month ago

Speaking at dataMinds Saturday & Techorama 2024

I have the pleasure to announce I'll be presenting at two conferences this spring. The…

2 months ago