Solved

SSIS Package Hangs for a long time

Posted on 2014-07-28
3
2,938 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now