Solved

SSIS Package Hangs for a long time

Posted on 2014-07-28
3
3,393 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
[X]
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
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 40

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

691 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