title: SSIS Package Script Task Editor Stopped Working
body: <p>I have been happily editing SSIS packages on my PC for the last several years (I mean with the same installed OS and software) until recently when the &quot;Edit Script...&quot; button on the Script Task Editor dialog box stopped working.  It would just do nothing when I clicked that button.  I was using Visual Studio 2017 but I had VS 2015, 2013, and 2010 install on the same machine.  I had multiple versions of sql server data tool installed as well (and multiple versions of VSTA and supporting libraries installed).  I have tried many things to get this to work with no success so I decided to uninstall all versions of Sql Server Data Tools and all versions of Visual Studio Tools for Applications (to avoid any issues I may have introduced by all the reinstallations of components I did while trying to fix this) and then install Visual Studio 2019 with the &quot;Data And Storage Processing&quot; workload.</p>
  <p>I assumed a fresh install would work but it did not.  I installed the SSIS extension in VS 2019 and created a new SSIS project.  When I add a script task and open it up to edit it and then click on the &quot;Edit Script...&quot; button, I get the following error:</p>
  <blockquote>
  <blockquote>
  <p>===================================</p>
  <p>Cannot show Visual Studio 2015 Tools for Applications editor. (Microsoft Visual Studio)</p>
  <p>===================================</p>
  <p>Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications, Version=16.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (mscorlib)</p>
  <hr />
  <p>Program Location:</p>
  <p>Server stack trace:
  at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.&lt;&gt;c__DisplayClass4.b__3()
  at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]&amp; outArgs)
  at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)</p>
  <p>Exception rethrown at [0]:
  at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
  at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData&amp; msgData)
  at System.Func<code>1.EndInvoke(IAsyncResult result) at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.RunFunc[TResult](Func</code>1 function)
  at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.LoadNewProject(String templatePath, String templateName, String projectName)
  at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()</p>
  <p>===================================</p>
  <p>Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.</p>
  </blockquote>
  </blockquote>
  <p>Initially I think the version numbers it reported were different from what is listed in this error message but I have since tried installing multiple versions of VSTA from <a href="https://www.microsoft.com/en-us/download/details.aspx?id=58316&amp;WT.mc_id=DX_MVP4025064" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=58316&amp;WT.mc_id=DX_MVP4025064</a> and <a href="https://www.microsoft.com/en-us/download/details.aspx?id=56046" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=56046</a></p>
  <p>I don't remember installing any new software recently on this PC so I am confused as to why this started failing out of the blue and why a fresh installation has the same problem.</p>
  <p>Has anyone else experienced anything like this (and if so, do you know why it happened)? Does anyone have some suggestions about how I should proceed to get productive again as quickly as possible?  Any help would be much appreciated, thank you.</p>