isvisualstudio2012 proinstall()方法在运行VS2012中的SSIS包时没有发现错误

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:

我正在尝试在Visual Studio 2012中运行一个SSIS包。当我点击“开始”按钮时，我在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)

我能够愉快地开发和运行Visual Studio 2012的SSIS包，几天前没有任何问题(我在周末重新启动了我的电脑，并且安装了一些windows更新)

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.

我在technet上找到了一些关于这方面的最新文章，所以我怀疑这是周末更新时出现的问题。一篇文章说，他通过重新安装解决了这个问题，但当然，如果没有必要，我宁愿不走那条路。

6 个解决方案

#1

1. Open the Developer Command Prompt for VS212 as Administrator

   作为管理员打开VS212的Developer命令提示符

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

   执行命令cd“C:\程序文件(x86)\Microsoft Visual Studio 11.0\Common7\IDE\ private总成”

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

   执行命令gacutil /if . sqlserver . dtd . design .dll

4. restart Visual Studio

   重新启动Visual Studio

Source msdn Fail to start project

源msdn未能启动项目

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.

对于visual Studio 2013，在第2点执行命令cd“C:\程序文件(x86)”，然后执行第3点和第4点。

#2

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"

\程序文件\微软SDKs\Windows\v8.0A\bin\NETFX 4.0工具\gacutil。\程序文件\ microsoftvisualstudio 11.0\Common7\ \ \ \ \ \ \ \ \ \软件\ microsoft.sqlserver.dts.designdll "

Make sure that your dll file and Gacutil.exe file locations are correct. It may be different in other systems.

确保你的dll文件和Gacutil。exe文件位置是正确的。在其他系统中可能会有所不同。

Note: You should open your “Command Prompt” as an administrator to run the above command.

注意:您应该以管理员的身份打开“命令提示符”来运行上述命令。

#3

I experienced the same problem.

我也遇到过同样的问题。

Downloaded and installed SQL Server 2012 SP2 and that seemed to have fixed the problem.

下载并安装了SQL Server 2012 SP2，这似乎解决了问题。

Hope this helps!!

希望这有助于! !

#4

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.

这可能是因为您有Visual Studio 2013和它安装的BI工具。如果您对同一包使用Visual Studio 2013，它可能会工作。另一个建议gacutil注册旧版本的答案可能在以后使用SSIS的Visual Studio 2013工具时产生负面影响。

#5

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.)

我有同样的事情发生，奇迹般地，我的机器已经“修好”了。(我实际上是在Win 8.1机器和一台新的Win 7机器上发生的。)

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.

我和同事注意到我的IDE中缺少SSIS工具箱。在打开SSIS包后，进入SSIS菜单，并添加回我的“SSIS工具箱”中，出于某种奇怪的原因，我的包现在运行良好。

I'm guessing a recent update reset the behavior of the IDE.?.?

我猜最近的更新重置了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.

我卸载了SQL Server 2012 SP2 HF 5522，然后重新启动，然后卸载了SQL Server 2012 SP2，然后再重新启动，我的IDE仍然给出了错误。然后我尝试应用SQL Server SP1 CU 9，但是我的环境说不需要它。然后我最后一次重启。

My SSIS Packages run again.

我的SSIS包再次运行。

Voodoo...

巫毒教……

#6

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.

如果您在这个问题之后(正如我所做的那样)在这个问题上运行，那么它似乎在稍后的SSDT-BI工具安装程序中被修复了。不是那个，就是重新安装的过程帮我修好了。

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.

下载页面上安装程序的文件名没有改变，但是2015年3月发布了一个新版本。新版本号为11.0.5583.0，导致此错误的前一个版本号为11.0.3436.0。

So a simple update might be sufficient. It worked for me with no changes to the GAC.

所以一个简单的更新就足够了。它对我起作用了，没有改变GAC。