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

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

Active

Type:	Bug
ID:	776248
Opened:	1/10/2013 6:55:55 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2012 - Enterprise Edition

Developer Tools (SSDT, BIDS, etc.)

Windows Server 2012 Standard

US English

During installation just install first SQL Server Integration Services.
After installation is finished, launch the Installation Wizard again and install SQL Server Data Tools.

Impossible to import a SSIS package from SQL Server 2008/2005 and upgrade it to 2012. As soon as a Script component is in the package you the error as mentioned above.

The reason is that the component Microsoft Visual Studio Tools for Applications x86 Runtime 3.0 in "Programs and Features" is not installed when you use the installation order as mentioned in the "Steps to Reproduce". On Microsoft Visual Studio Tools for Applications x64 Runtime 3.0 is installed.
When you select both SQL Server Data Tools and Integration Services, Both x64 and x86 Microsoft Visual Studio Tools for Applications Runtime 3.0 are installed.

Both x64 and x86 Microsoft Visual Studio Tools for Applications Runtime 3.0 are installed even when SQL Server Data tools and Integration Services are installed seperatly

X64

Other (e.g. VM Ware, specify in Description)

0 attachments

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.