How to fix “Cannot show Visual Studio 2010 Tools for Applications Editor” in SSIS Package

Scenario

You are developing a SSIS package for your BI application. You are configuring a Script Task component and this is the first time you use this component. When you open the [Script Task Editor], and click on [Edit Script…] as shown below 

clip_image001

You encounter an error as shown below

  • Cannot show Visual Studio 2010 Tools for Application 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)

clip_image002

Cause

The Visual Studio Runtime is a 32-bit application, and by default, the Visual Studio Tools for Application 32-bit (VSTA_RT) is not installed on a 64-bit server.

Solution

To fix this error, we need to install Visual Studio Tools for Application 32-bit runtime. This runtime installer file is bundled with the MSSQL Server Installer. The installation steps are as follows

  • Mount the MSSQL Installation DVD, let’s say it’s mounted to drive F
  • Locate the runtime file at F:\redist\VSTA\runtime\x86\VSTA_RT30.msi
  • Install the VSTA_RT30.msi and reopen the Visual Studio
  • The error will disappear
Advertisements

3 thoughts on “How to fix “Cannot show Visual Studio 2010 Tools for Applications Editor” in SSIS Package

  1. I have this same problem and I have SQL server standard edition installed.What is the licence requirement for VSTA_RT30.msi ? Is the msi files available in Standard edition of sql server?
    or Is it free to download from microsoft ?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s