In a recent thread on the SSIS forums on MSDN, a poster was bemoaning the number of steps required to open the VSA script editor for the Script Task in SSIS. And I was sharing his pain.
Fortunately, there is a little improvement on the horizon, but just a little at this point. In CTP5 of SQL Server 2008 the “Edit Script” button (note that it has been renamed from “Design Script” but that the keyboard shortcut key remains “S”) is now on the first tab of the editor dialog box, so one fewer steps is required to open VSTA.
Also note that C# is the default language in the Editor dialog box. Oh, how I look forward to being able to use C# for my SSIS development needs…
But we still need that “Edit Script” context menu item, don’t we?