cannot show Visual Studio Tools for Application editor in SSIS 2012

Question

When I click on EDIT SCRIPT button for Script Task in SSIS 2012 package,

It does not open the Script editor rather it shows:

"cannot show Visual Studio Tools for Application editor"

Couls not load file or assembly "Microsoft.visualstudio.tools.applications.core version=10.0.0.0 ...." system can not find the file assembly specified.

I tried the solutions provided in the following links:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e5337b0c-7f70-4603-859e-fbc7d0cf1c37

SSIS Script Editor throws an exception

Answer 1

It is year 2021, when searching for the error, this is the top hit. The solution that worked for me with Visual Studio 2019 is to download and install "Visual Studio Tools for Applications 2019"

Link: https://www.microsoft.com/en-us/download/details.aspx?id=58317&WT.mc_id=DX_MVP4025064

Interestingly, this is not provided as an option in Visual Studio installer. The above needs to be manually downloaded and installed.

Answer 2

First of all go to Program and Features and check whether you have "Microsoft Visual Studio Tools for Applications x86 Runtime 3.0" installed. Most probably you will see this below "Microsoft Visual Studio Tools for Applications x64 Runtime 3.0"

If it is not installed then you have the same issue that i have. To resolved this error, I put in my SQL Server installation disk. Then go to redist->VSTA->runtime->x86 and then run VSTA_RT30.msi