IsVisualStudio2012ProInstalled() method not found error when running an SSIS package from VS2012

Eric Petroelje picture Eric Petroelje · Jul 14, 2014 · Viewed 44.5k times · Source

I'm trying to run an SSIS package in Visual Studio 2012. When I click the "Start" button I get this very odd error in a popup from Visual Studio:

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

Clicking on the show technical information, I get this stack trace:

===================================

Failed to start project (Microsoft Visual Studio)

===================================

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

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

Has anyone ever seen this error before or know what the issue might be? A bit of googling turned up absolutely nothing for me.

I was able to happily develop and run SSIS packages from Visual Studio 2012 without any issues just a couple days ago (I did reboot my PC over the weekend and some windows updates were installed)

ETA:

I was able to find a couple very recent technet posts about this here and here so I suspect this was something that broke in an update over the weekend. One post says he solved the issue by reinstalling, but of course I'd rather not go that route if I don't have to.

Answer

Albert picture Albert · Jul 16, 2014
  1. Open the Developer Command Prompt for VS212 as Administrator

  2. execute the command cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"

  3. execute the command gacutil /if Microsoft.SqlServer.Dts.Design.dll

  4. restart Visual Studio

Source msdn Fail to start project

For visual Studio 2013 execute the command cd "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies" in point 2 and then execute point 3 and 4.