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.
Open the Developer Command Prompt for VS212 as Administrator
execute the command cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"
execute the command gacutil /if Microsoft.SqlServer.Dts.Design.dll
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.
The following is the command we have to use to resolve the issue:
"C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\gacutil.exe" /if "C:\Program Files\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\Microsoft.SqlServer.Dts.Design.dll"
Make sure that your dll file and Gacutil.exe file locations are correct. It may be different in other systems.
Note: You should open your “Command Prompt” as an administrator to run the above command.
I experienced the same problem.
Downloaded and installed SQL Server 2012 SP2 and that seemed to have fixed the problem.
Hope this helps!!
This is probably happening because you have Visual Studio 2013 and the BI tools for it installed also. If you use Visual Studio 2013 for the same package it will probably work. The other answer suggesting the run of gacutil to register the old version may have negative impacts later when you want to use the Visual Studio 2013 tools for SSIS.
I had the exact same thing just happen and miraculously now my machine has been "fixed".
(I actually had it happen on both a Win 8.1 machine and a new Win 7 machine.)
My colleague and I noticed that the SSIS toolbox was missing from my IDE. After opening an SSIS package, going to the SSIS menu, and adding back in my "SSIS Toolbox", for some strange reason, my packages now run fine.
I'm guessing a recent update reset the behavior of the IDE.?.?
If this black magic worked for me, I'm hoping it will work for others.
EDIT:
I had the behavior revert itself.
I uninstalled SQL Server 2012 SP2 HF 5522, then rebooted
I then uninstalled SQL Server 2012 SP2, then rebooted
After that, my IDE still gave the error.
I then tried to apply SQL Server SP1 CU 9, but my environment said it wasn't needed.
I then rebooted one last time.
My SSIS Packages run again.
Voodoo...
If you're running across this issue somewhat after the fact (as I did), it appears that it has been fixed in a later release of the SSDT-BI tools installer. Either that, or the process of re-installing fixed it for me.
The file name of the installer on the download page has not changed, but there was a new version released in March of 2015. The new version number is 11.0.5583.0, and the previous version that was causing this error was 11.0.3436.0.
So a simple update might be sufficient. It worked for me with no changes to the GAC.
