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

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…

5 days ago

dataMinds Connect 2024 – Session Materials

The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…

4 weeks ago

Connect to Power BI as a Guest User in another Tenant

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…

2 months ago

How to use a Script Activity in ADF as a Lookup

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…

4 months ago

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS…

4 months ago

Speaking at dataMinds Connect 2024

I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…

5 months ago