Discussion:
Cannot edit SSIS Script Task in Visual Studio .NET 2008
(too old to reply)
TomM
2008-11-14 13:38:03 UTC
Permalink
I have an SSIS package created in Visual Studio .NET 2008 which contains a
Script Task. When I open the Script Task Editor and click on the 'Edit
Script' button. I get the following error message. When I check the GAC I
have version 8.0.0.0 of the missing file but not 9.0.0.0.

On the same PC I have the developer edition of SQL Server 2008 installed
with the Integration Services option.

Thanks.

TITLE: Microsoft Visual Studio
------------------------------

Cannot show Visual Studio 2008 Tools for Applications editor.

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.
The system cannot find the file specified.
(Microsoft.SqlServer.VSTAScriptingLib)

------------------------------
BUTTONS:

OK
------------------------------
--
TomM
Charles Wang [MSFT]
2008-11-17 04:01:26 UTC
Permalink
This post might be inappropriate. Click to display it.
TomM
2008-11-17 12:05:01 UTC
Permalink
I had already uninstalled and reinstalled, however, I did not do this with
only the Shared Features. This appeared to be the trick.

Thank you, Charles!
--
TomM
Post by Charles Wang [MSFT]
Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.
From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.
The error message indicates that the assembly was not correctly installed on your computer. I recommend
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.
Hope this helps. If you have any other questions or concerns, please feel free to let me know.
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
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Charles Wang [MSFT]
2008-11-18 12:28:41 UTC
Permalink
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: ***@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Roberto
2009-10-29 20:58:05 UTC
Permalink
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.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()
Post by Charles Wang [MSFT]
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
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Satyajit Nalavade
2010-08-05 17:56:03 UTC
Permalink
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
Post by Roberto
I have the same problem. I uninstalled and installed again as whole SQL
===================================
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()
Post by Charles Wang [MSFT]
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
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
mlundblad
2010-08-09 16:33:01 UTC
Permalink
Post by Satyajit Nalavade
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
Post by Roberto
I have the same problem. I uninstalled and installed again as whole SQL
[quoted text clipped - 44 lines]
Post by Roberto
Post by Charles Wang [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
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.

Loading...