Chris Michalczuk
asked on
SSIS Package Hangs for a long time
every time I open a specific package it hangs for ages and eventually does process but I get this
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.P ipeline.Wr apper.IDTS Object100' . This operation failed because the QueryInterface call on the COM component for the interface with IID '{203E24BD-5203-4C76-AFC7- 7C8545EBA1 A0}' 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:
Server stack trace:
at System.StubHelpers.StubHel pers.GetCO MIPFromRCW (Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.SqlServer.Dts.Pi peline.Wra pper.IDTSO bject100.g et_Name()
at Microsoft.DataTransformati onServices .PipelineD esignTimeO bject.DoGe tName()
at System.Runtime.Remoting.Me ssaging.St ackBuilder Sink._Priv ateProcess Message(In tPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Me ssaging.St ackBuilder Sink.Async ProcessMes sage(IMess age msg, IMessageSink replySink)
Exception rethrown at [0]:
at System.Runtime.Remoting.Pr oxies.Real Proxy.EndI nvokeHelpe r(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Pr oxies.Remo tingProxy. Invoke(Obj ect NotUsed, MessageData& msgData)
at Microsoft.DataTransformati onServices .PipelineD esignTimeO bject.GetN ameDelegat e.EndInvok e(IAsyncRe sult result)
at Microsoft.DataTransformati onServices .PipelineD esignTimeO bject.get_ Name()
at Microsoft.DataTransformati onServices .PipelineC omponentMe tadata.get _Name()
at Microsoft.DataTransformati onServices .Design.Dt sComponent Designer.V alidateCom ponent(Boo lean& reinitializeCalled)
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.P
--------------------------
Program Location:
Server stack trace:
at System.StubHelpers.StubHel
at Microsoft.SqlServer.Dts.Pi
at Microsoft.DataTransformati
at System.Runtime.Remoting.Me
at System.Runtime.Remoting.Me
Exception rethrown at [0]:
at System.Runtime.Remoting.Pr
at System.Runtime.Remoting.Pr
at Microsoft.DataTransformati
at Microsoft.DataTransformati
at Microsoft.DataTransformati
at Microsoft.DataTransformati
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think this solved it
Where (on which location) and how (what tools) are you using to "...open a specific package ..."?