Cannot edit SSIS Script Task in SQL Server BIDS 2008

JohnBarryAtUconn

2009-10-30 13:33:01 UTC

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

Post by Roberto
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)
===================================
"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)
------------------------------
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()