Script task won't open Editor in visual studio 2013

Question

I am using SSIS 2014 and Visual Studio 2013. When I click on Edit Script button of script task no error nothing happens but script editor doesn't open. Nothing happens I have installed on my machine:

• Microsoft Visual Studio Tools for Applications 2012
• Microsoft Visual Studio Tools for Applications x64 Runtime 3.0

Answer 1

I had the same problem with the following setup:

• Visual Studio 2017 Community Edition (15.6.6)
• SSDT 2017 (15.5.2)
• SQL Server 2017 Developer Edition

I solved repairing the installation of Visual Studio Tools for Application 2017 from the control panel:

Answer 2

I've just had exactly the same problem. I've got both SSDT and SSDT BI installed for VS2012 and VS2013 but still couldn't get the Edit Script to open. I repaired my install of VSTA 2012 and also newly installed VSTA 2013 but still no luck.
Turns out I just had to run VS 2013 as administrator and it worked! Might not be the solution for all but worth a try if you've got all the correct applications installed.

Answer 3

I ran into this same exact issue. Try installing Sql Server Data Tools 2012 here as well as Sql Server Data Tools 2013 here. I am not sure why you would need both but for some reason the script task when only having SSDT 2013 installed still seemed to want to reference 2012 (see screen shot below).

Hopefully this helps.

Answer 4

I have the same setup VS 2013 Professional, with SQL 2014 Data Tools. My VstaProjects window would open, but the ScriptMain.vb window, with the framework, would not open. Repair was not an option, so the tech removed and reinstalled SSDT 2014. It works now.