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)