Microsoft SQL Server Data Tools 包未正确加载
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21781494/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Microsoft SQL Server Data Tools package did not load correctly
提问by sthede
Everything about my VS 2013 install appears to be working correctly except when I right click on a table in Server Explorer. I am trying to use the data tools to view the table, which is in a MS SQL database. Here is the message VS 2013 pops when I right click:
我的 VS 2013 安装的所有内容似乎都正常工作，除非我在服务器资源管理器中右键单击一个表。我正在尝试使用数据工具查看 MS SQL 数据库中的表。这是当我右键单击 VS 2013 时弹出的消息：
The 'Microsoft SQL Server Data Tools' package did not load correctly.
The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by examining the file 'C:\Users\...\AppData\Roaming\Microsoft\VisualStudio.0\ActivityLog.xml'.
Here are the last few lines of the ActivityLog.xml, btw one of the most cryptic log files I have ever read:
这是 ActivityLog.xml 的最后几行，顺便说一句，这是我读过的最神秘的日志文件之一：
1222 Begin package load [Microsoft SQL Server Data Tools] {00FEE386-5F9F-4577-99F4-F327FAFC0FB9} VisualStudio 2014/02/14 13:50:50.112
1223 ERROR SetSite failed for package [Microsoft SQL Server Data Tools] {00FEE386-5F9F-4577-99F4-F327FAFC0FB9} 80131534 VisualStudio 2014/02/14 13:50:50.641
1224 Entering function CVsPackageInfo::HrInstantiatePackage {FEF13793-C947-4FB1-B864-C9F0BE9D9CF6} VisualStudio 2014/02/14 13:50:50.650
1225 Warning Unexpected system error mode before loading package [SqlStudio Editor Package] {FEF13793-C947-4FB1-B864-C9F0BE9D9CF6} VisualStudio 2014/02/14 13:50:50.650
1226 Begin package load [SqlStudio Editor Package] {FEF13793-C947-4FB1-B864-C9F0BE9D9CF6} VisualStudio 2014/02/14 13:50:50.650
1227 End package load [SqlStudio Editor Package] {FEF13793-C947-4FB1-B864-C9F0BE9D9CF6} VisualStudio 2014/02/14 13:50:50.691
1228 ERROR End package load [Microsoft SQL Server Data Tools] {00FEE386-5F9F-4577-99F4-F327FAFC0FB9} 80131534 VisualStudio 2014/02/14 13:50:51.044
Here is what I have done to try to solve this problem:
这是我为尝试解决此问题所做的工作：
- Disabled all plugins/extensions
- Checked for and applied all updates for all extensions and VS 2013 including Update 1
- Did a full VS 2013 install repair operation
- 禁用所有插件/扩展
- 检查并应用了所有扩展和 VS 2013 的所有更新，包括更新 1
- 做了完整的VS 2013安装修复操作
VS 2013 now includes the SSDT tools in VS 2013, so I cannot download and install anything, it is suppose to already be working. Not unless someone knows of a different trick.
VS 2013 现在在 VS 2013 中包含 SSDT 工具，所以我无法下载和安装任何东西，它应该已经在工作了。除非有人知道不同的技巧。
I am out of ideas and I have searched quite extensively about this, most of it applied to VS 2012. If anyone has any good suggestions, that would be awesome.
我没有想法，我已经对此进行了广泛的搜索，其中大部分都适用于 VS 2012。如果有人有任何好的建议，那就太棒了。
回答by Daniel Ferreira
Go to 'Add/Remove Programs' in Control Panel, search for "Microsoft SQL Server Data Tools" and repair. Worked for me.
转到“控制面板”中的“添加/删除程序”，搜索“ Microsoft SQL Server Data Tools”并修复。对我来说有效。
回答by Nick DeVore
And just in case none of those work, you can go to the Download Latest SQL Server Data ToolsMicrosoft page itself. It lists out the versions of the tool set for each version of Visual Studio
万一这些都不起作用，您可以转到下载最新的 SQL Server 数据工具Microsoft 页面本身。它列出了每个版本的 Visual Studio 的工具集版本
回答by James Wierzba
I had the same issue. After trying the other answers and not resolving the issue, I was able to resolve it by
我遇到过同样的问题。在尝试了其他答案但没有解决问题后，我能够通过
- Uninstalling Sql Server Data Tools from the control panel
- Navigating to Extensions and Updates
- Go to Updates tab -> Update Visual Studio
- You should get a prompt to enable optional features, choose SSDT
- Wait for the long installation process, restart if necassary.
- 从控制面板卸载 Sql Server Data Tools
- 导航到扩展和更新
- 转到更新选项卡 -> 更新 Visual Studio
- 您应该会收到启用可选功能的提示，选择 SSDT
- 等待漫长的安装过程，必要时重新启动。
Fixed it for me
为我修好了
回答by kemals
It is not in VS after 2012. Try this link, install separately
2012年以后就没有VS了。试试这个链接，单独安装
http://www.microsoft.com/en-us/download/details.aspx?id=42313
http://www.microsoft.com/en-us/download/details.aspx?id=42313
