Script task won't open Editor in visual studio

2019-03-25 06:53发布

问题:

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

回答1:

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.



回答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.



回答3:

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: