Microsoft SQL Server Data Tools package did not load correctly

Question

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:

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\12.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:

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

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.

Answer 1

Go to 'Add/Remove Programs' in Control Panel, search for "Microsoft SQL Server Data Tools" and repair. Worked for me.

Answer 2

And just in case none of those work, you can go to the Download Latest SQL Server Data Tools Microsoft page itself. It lists out the versions of the tool set for each version of Visual Studio