SSIS 2014: Can't open script transformation editor

I'm trying to use a script tranformation in a data flow but i can't open the editor!

nothing happens in SSDT when i click the edit script button

I noticed the following in the event viewer which i'm guessing is what's happening

The description for Event ID 0 from source VSTA cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

devenv(5688): Error: System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
   at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
   at System.Diagnostics.Process.Start()
   at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
   at Microsoft.VisualStudio.Tools.Applications.IdeCommunications.IdeServer.Launch()
   at Microsoft.VisualStudio.Tools.Applications.IdeCommunications.IdeCommunicationsServer.Microsoft.VisualStudio.Tools.Applications.IdeCommunications.External.IIdeCommunications.Launch() 1/09/2015 5:21:14 PM

the message resource is present but the message is not found in the string/message table

Any tips on what to do?

the other weird thing is that it's SSDT for VS2013, but the editor shows it's trying to run "Microsoft Visual C# 2012" as the scripting language. And I can't change it to J# or VB.NET (or whatever the other options are)

September 1st, 2015 3:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics