Cannot edit SSIS Script Task in SQL Server BIDS 2008

Have you intsalled Microsoft Visual Studio 2008 SP1 (Service Pack)?

"Roberto" wrote:

> I have a SSIS package with Script Task created in SQL Server BIDS 2008 . When
> I open the Script Task Editor and click on the 'Edit Script' button. I get a
> following error message. I uninstalled and installed again as whole SQL
> Server 2008 as shared features. Nothing changed.
>
> ===================================
>
> Cannot show Visual Studio 2008 Tools for Applications editor. (Microsoft
> Visual Studio)
>
> ===================================
>
> The VSTA designer failed to load:
> "System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM
> class factory for component with CLSID {7525139F-BB6B-447A-A81E-360B2197C3B2}
> failed due to the following error: 80040154.
> at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()"
> (Microsoft.SqlServer.VSTAScriptingLib)
>
> ------------------------------
> Program Location:
>
> at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()
> at
> Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
> languageID, String projectname, String projectext, Boolean bCleanupOnClose)
> at
> Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
> languageID, String projectname, String projectext)
> at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()
>
>