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.VSTAScriptingEngin e.EnsureDTEObject()"
(Microsoft.SqlServer.VSTAScriptingLib)

------------------------------
Program Location:

at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngin e.EnsureDTEObject()
at
Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngin e.InitNewScript(String
languageID, String projectname, String projectext, Boolean bCleanupOnClose)
at
Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngin e.InitNewScript(String
languageID, String projectname, String projectext)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTas kUI.ShowIDE()

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

"Roberto" wrote: