Solved

SSIS Package Hangs for a long time

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Schedule SSIS package in WIndows Task Scheduler 8 79
Re-appearing SQL Server Agent jobs 7 43
Update one rows based on previous row 5 30
Can I skip a node in XML? 9 35
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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