Script task won't open Editor in visual studio 2013

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:

enter image description here


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.


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.

enter image description here

Tags:

Visual Studio

Ssis

Vsta

Related

Appcompat v21 Toolbar elevation pre-lollipop 504 Gateway Time-out The server didn't respond in time. How to fix it? Why VIM backup filenames are not correct? 'backupdir' option not performing as expected Singleton in Swift The client and server cannot communicate, because they do not possess a common algorithm - ASP.NET C# IIS TLS 1.0 / 1.1 / 1.2 - Win32Exception How does the pyspark mapPartitions function work? Adding multiple shadows/rectangles to ggplot2 graph How to get current longitude and latitude using CLLocationManager-Swift Understanding PHP type coercion IOException: The process cannot access the file 'file path' because it is being used by another process Swift - Unit testing functions that involve IBOutlets? Should EndReceive ever return zero if the socket is still connected?

Recent Posts