Scripts and SSDT-BI 2013

Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means using Visual Studio 2013 (I explain in this blog post how I set this up using Visual Studio online). However, I got a message saying there was a compatibility issue with Visual Studio 2012.

vs2012compat

(this isn’t the actual screenshot, because I forgot to take one, but it looks a lot like the one I got)

After clicking Run program, nothing happened, except for the very annoying message that Visual Studio is busy (one of the most annoying messages you can get).

busy

After a quick online search, I found a forum topic where it was suggested to install a patch for Visual Studio 2012, since the .NET 4.5 framework could cause instability issues (of course it does). Unfortunately, it did not work.

Then I downloaded and installed SQL Server 2014 service pack 1 (you never know), but it didn’t help as well. My mental state become something like this:

rage

Then I realized something: SSDT-BI 2013 (aka Visual Studio 2013) tries to open the VSTA editor of Visual Studio 2012. Is it installed? It turns out VS 2012 was installed, but as an empty shell (probably by the set-up of VS 2013, because I didn’t install it myself). So I downloaded SSDT-BI 2012, installed it and lo and behold, I could open a script task/component in VS 2013!

Moral of the story:
you have to install SSDT-BI 2012 if you want to edit scripts in SSDT-BI 2013. Quite retarded if you ask me, but that’s how it is…

Koen Verbeeck

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, 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.

7 thoughts on “Scripts and SSDT-BI 2013

  1. Believe it or not, I got it to work by double clicking on C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\vsta.exe the next time I went into SSDT VS 2013 and hit edit task it opened up. I had installed both 2012 and 2013 before this.

Leave a Reply

Your email address will not be published. Required fields are marked *