Thursday, March 12, 2015

Visual Studio Version Error

Here's a quick fix for a very annoying little problem. Every once in a while, when I attempt to execute a package in SSDT, I receive an error message that seems to relate to the version of Visual Studio 2012 I have installed.

If you need to copy this error message, it reads:

Method not found: 'Boolean Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled()'.

I believe this happens almost every time I install updates to Visual Studio plugins or updates Visual Studio itself. The fix is quick and easy, but it is annoying to have to do it every so often.

First, make sure you close SSDT and open the Developer Command Prompt for Visual Studio 2012 as an Administrator. You can find this in the Windows start menu (or start screen, depending on what version of Windows you are using).

In the command prompt, navigate to the private assemblies folder for Visual Studio by executing the following command.

cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"

Next, execute the following command to register the DTS.Design.dll.

gacutil /if Microsoft.SqlServer.Dts.Design.dll

Once that is complete, start SSDT and you should be able to execute SSIS packages again.

1 comment: