When I click the EDIT SCRIPT button of the script task in the SSIS 2012 package
The Script Editor does not open, but the following is displayed:
“Unable to display Visual Studio Tools for Application Editor”
Couls does not load files and assemblies “Microsoft.visualstudio.tools.applications.core version = 10.0.0.0 ….” The system cannot find the specified file layout.
I tried the solutions suggested by the links below:
SSIS Script Editor throws an exception
Visual Studio Runtime is a 32-bit application and by default Visual Studio Tools for Applications (VSTA_RT) is not installed on a 64-bit server.
Fixed VSTA Editor Error In SSIS 2012
The Script task in SSIS 2012 is a great tool when you need to use C # or VB code to perform a function that other tasks built into SSIS cannot. It uses Visual Studio Tools for Applications (VSTA). Â One limitation of using the Script task is that if you encounter a problem with your code when you try to run the task, youget a generic error message: