SSIS 脚本编辑器抛出异常 [英] SSIS Script Editor throws an exception

问题描述

我有 SQL Server 2012、SSIS、SSDT 和 Visual Studio 2010.我可以创建一个新的 SSIS 包并添加一个脚本任务，但是如果我尝试打开该脚本任务的脚本编辑器，我会收到以下错误:

I have SQL Server 2012, SSIS, SSDT and Visual Studio 2010. I can create a new SSIS package and add a Script Task, but if I attempt to open the Script Editor for that Script Task I get the following error:

TITLE: Microsoft Visual Studio
------------------------------

Cannot show Visual Studio 2010 Tools for Applications editor.

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

根据我自己对此错误的调​​查，我发现 Visual Studio Tools for Applications 似乎是 MS Office 2007 及更高版本的一部分.这似乎是一个奇怪的依赖项，但我安装 MS Office 2010 只是为了咧嘴笑.它没有改变任何东西.我还应该尝试什么?

From my own investigation into this error, I found that Visual Studio Tools for Applications appears to be a part of MS Office 2007 and higher. This seemed like an odd dependency for to have, but I installed MS Office 2010 just for grins. It didn't change anything. What else should I try?

推荐答案

今天早上我发现了我的问题.当我卸载 SQL Server 2012(以及上个月升级时留下的 2008 的残余)时，我还卸载了 3 个实际上属于 Visual Studio 2010 的包.如果我不这样做，重新安装 SQL Server 2012 可能会完成诀窍，但我发现了新的错误.当我从 Visual Studio 2010 分发媒体重新安装这 3 个包时，一切都开始工作了.

I figured out my problem this morning. When I uninstalled SQL Server 2012 (and the remnants of 2008 left behind when I upgraded last month) I also uninstalled 3 packages that were actually part of Visual Studio 2010. Had I not done this, a reinstallation of SQL Server 2012 would probably have done the trick, but instead I found new errors. When I reinstalled these 3 packages from the Visual Studio 2010 distribution media, everything started working.

有问题的 3 个包是:

The 3 packages in question were:

• Microsoft SQL Server 2008 R2 数据层应用程序项目
• Microsoft SQL Server 2008 R2 数据层应用程序框架
• Microsoft SQL Server 2008 R2 Transact-SQL 语言服务

这篇关于SSIS 脚本编辑器抛出异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！