Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSIS Package Hangs for a long time

Posted on 2014-07-28
3
3,138 Views
Last Modified: 2016-02-11
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.Pipeline.Wrapper.IDTSObject100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{203E24BD-5203-4C76-AFC7-7C8545EBA1A0}' 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.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
   at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100.get_Name()
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.DoGetName()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.GetNameDelegate.EndInvoke(IAsyncResult result)
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.get_Name()
   at Microsoft.DataTransformationServices.PipelineComponentMetadata.get_Name()
   at Microsoft.DataTransformationServices.Design.DtsComponentDesigner.ValidateComponent(Boolean& reinitializeCalled)
0
Comment
Question by:Chris Michalczuk
3 Comments
 
LVL 13

Accepted Solution

by:
Russell Fox earned 500 total points
ID: 40227169
I've seen people fix this by registering the dts.dll: close the solution, open the command prompt and type "cd C:\Program Files\Microsoft SQL Server\90\DTS\Binn" and press <Enter>, then type "regsvr32 dts.dll" and press <Enter>. You should get a "dll registered" notice. Open the solution and see if it works for you.
0
 
LVL 39

Expert Comment

by:lcohan
ID: 40229099
"...every time I open a specific package..."

Where (on which location) and how (what tools) are you using to "...open a specific package ..."?
0
 

Author Closing Comment

by:Chris Michalczuk
ID: 40248173
I think this solved it
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question