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屋!