Cannot edit SSIS Script Task in Visual Studio .NET 2008

[TomM]

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]]

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
that you try uninstalling and installing your SQL Server 2008 workstation components again:
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
send feedback directly to my manager at: msd...@microsoft.com.
===========================================================
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.
=========================================================

[TomM]

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

[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
send feedback directly to my manager at: msd...@microsoft.com.
=========================================================

[Roberto]

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

[Nalavade@discussions.microsoft.com 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

[mlundblad]

Satyajit Nalavade 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
>

>> 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:

>[quoted text clipped - 44 lines]

>> > 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.