Visual Studio 2008 SP1 Crashes when opening .dtsx packages

Answered Visual Studio 2008 SP1 Crashes when opening .dtsx packages

  • Wednesday, January 05, 2011 4:43 AM
     
     

    Hello,

    I have SSIS packages developed before.  No problem whatsoever opening anyone of them before.

    Now, Visual Studio crashes when I try to get to Dataflow in some of the packages.  I am on a deadline, cannot figure it out why it crashes while I open those packages.

    Here is the errors when it crashes when I double click on the Dataflow or go to the Dataflow tab:

    Description:
      Stopped working

    Problem signature:
      Problem Event Name:    APPCRASH
      Application Name:    devenv.exe
      Application Version:    9.0.30729.1
      Application Timestamp:    488f2b50
      Fault Module Name:    msdds.dll
      Fault Module Version:    9.0.30729.1
      Fault Module Timestamp:    488f2e31
      Exception Code:    c0000005
      Exception Offset:    00012b6a
      OS Version:    6.1.7600.2.0.0.144.8
      Locale ID:    1033

    Read our privacy statement online:
      http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

    If the online privacy statement is not available, please read our privacy statement offline:
      C:\Windows\system32\en-US\erofflps.txt

     

    I also see this error when Visual Studio loading the packages.

     

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

    Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)). (Microsoft Visual Studio)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.ComponentImpl.get_Site()
       at Microsoft.SqlServer.Dts.Runtime.DtsContainer.get_Site()
       at System.ComponentModel.ReflectTypeDescriptionProvider.GetCache(Object instance)
       at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.GetCache(Object instance)
       at System.ComponentModel.TypeDescriptionProvider.GetCache(Object instance)
       at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.GetCache(Object instance)
       at System.ComponentModel.TypeDescriptor.GetAttributes(Object component, Boolean noCustomTypeDesc)
       at System.ComponentModel.TypeDescriptor.GetAttributes(Object component)
       at System.ComponentModel.Design.MenuCommandService.EnsureVerbs()
       at System.ComponentModel.Design.MenuCommandService.FindCommand(Guid guid, Int32 id)
       at System.ComponentModel.Design.MenuCommandService.FindCommand(CommandID commandID)
       at Microsoft.DataWarehouse.VsIntegration.Designer.Host.CommandTargetMenuService.InvokeCommand(CommandID commandID)

     

    Please help


    Sincerely Thank You !

All Replies