Cannot edit SSIS Script Task in Visual Studio .NET 2008

Discussion in 'microsoft.public.sqlserver.dts' started by TomM, Nov 14, 2008.

  1. TomM

    TomM Guest

    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)
     
    TomM, Nov 14, 2008
    #1
    1. Advertisements

  2. 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: .
    ===========================================================
    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], Nov 17, 2008
    #2
    1. Advertisements

  3. TomM

    TomM Guest

    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


     
    TomM, Nov 17, 2008
    #3
  4. 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: .
    =========================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
    =========================================================
     
    Charles Wang [MSFT], Nov 18, 2008
    #4
  5. TomM

    Roberto Guest

    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()
     
    Roberto, Oct 29, 2009
    #5
  6. 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





     
    Satyajit Nalavade, Aug 5, 2010
    #6
  7. TomM

    mlundblad Guest


    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.
     
    mlundblad, Aug 9, 2010
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.