Home Dashboard Directory Help
Search

Could not load file or assembly ‘Microsoft.VisualStudio.Tools.Applications.Core’ by Pieter Vanhove


Status: 

Active


29
0
Sign in
to vote
Type: Bug
ID: 776248
Opened: 1/10/2013 6:55:55 AM
Access Restriction: Public
2
Workaround(s)
view
13
User(s) can reproduce this bug

Description

I was migrating SSIS packages from a SQL Server 2008 R2 server to a new SQL Server 2012.
When I loaded a package in the SQL Server Data Tools, I got the following error:
Cannot show Visual Studio 2010 Tools for Applications editor
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)

Details
Sign in to post a comment.
Posted by IreneKaLam on 3/30/2014 at 10:30 PM
Thanks. Good article and solve my problem.
Posted by Steve Powell on 10/3/2013 at 8:39 AM
To see a very thorough description/explanation of how to diagnose this see this blog post


http://pietervanhove.azurewebsites.net/?p=461
Sign in to post a workaround.
Posted by Steve Powell on 10/3/2013 at 8:37 AM
I've had exactly this issue.

I eventually figured out I could get all the components installed by running some of the installers on the SQL2012 DVD

redist/VSTA/designtime/VSTA_DT30msi
redist/VSTA/runtime/x64/VSTA_RT30.msi
redist/VSTA/runtime/x86/VSTA_RT30.msi

We have to have both X86 and x64 runtimes as packages can be run in native 64 bit mode or using the 32 bit runtime. I seemed to need the design time as well as the run time versions installed in order to execute the packages. Though this was a prod environment and we don't install BIDS/SSDT on prod systems.

Anyway once you have installed I did get some errors complaining the script hadn't been compiled, which is drivel as you no longer have an option to not compile scripts in SIS 2012. I assume that something lying around in the GAC was causing problems so I rebooted the machine.

All seemed to spring into life after that.
Posted by ckphua on 1/30/2013 at 1:38 AM
Both the x86 and x64 runtimes must be installed, currently one or both the runtimes may be missing depending on the order of the SQL Server 2012 installation. As a workaround, check in Control Panel - Programs and determine which of the component is missing (it should be listed as Microsoft Visual Studio Tools for Applications x86 or x64 Runtime 3.0). You can install the component manually from your installation disk or download from the \redist\VSTA\runtime\ folder.