Hi Tom,
I am very glad to see that the suggestions are helpful. If you have any other questions or
concerns, please feel free to let me know.

Thank you for choosing Microsoft. Hope you are overall very happy with our support
services!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
I am very glad to see that the suggestions are helpful. If you have any other questions or
concerns, please feel free to let me know.

Thank you for choosing Microsoft. Hope you are overall very happy with our support
services!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
I am very glad to see that the suggestions are helpful. If you have any other questions or
concerns, please feel free to let me know.

Thank you for choosing Microsoft. Hope you are overall very happy with our support
services!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
I am very glad to see that the suggestions are helpful. If you have any other questions or
concerns, please feel free to let me know.

Thank you for choosing Microsoft. Hope you are overall very happy with our support
services!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
I am very glad to see that the suggestions are helpful. If you have any other questions or
concerns, please feel free to let me know.

Thank you for choosing Microsoft. Hope you are overall very happy with our support
services!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

I have the same problem. I uninstalled and installed again as whole SQL
Server 2008 as shared features. Nothing changed. Still have the same problem:

===================================

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()



""Charles Wang [MSFT]"" wrote:

I am also getting exactly same error in Visual studio 2008 SSIS Script task
edit
is there any solution this is happening on 3 of our machines

Satyajit





"Roberto" wrote:

Satyajit Nalavade wrote:

Satyajit:

We found the issue to be a problem is Visual Studio Tools for Applications.
We fixed it by the following steps:

1. Uninstall VSTA
2. Repair the SQL 2008 R2 installation.