error message

Question

Hi Everyone,

whenever i opend my ssis package giving error message

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 '{30E5D0EF-E33D-4945-8A7F-F5178FC64C24}' 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)

what is the problem , how to handle this.

---

karteek_miryala

Answer 1

What is your ssis version en is the package created with the same version of BIDS?

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Hi Everyone,

whenever i opend my ssis package giving error message

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 '{30E5D0EF-E33D-4945-8A7F-F5178FC64C24}' 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)

what is the problem , how to handle this.

---

karteek_miryala

Does your SSIS package have any script component with codes inside ?

Can you rebuild the package and upload screenshot if there's the same error message.

---

Hope it helps! Vote if it's helpful! Simon MSN:[e-mail] Skype:simonlvpin

Answer 3

Hi Simon,

in my package contains script component, this package has been executed   a lot of time, their is no problem

but today when i am opening this package giving this error message. after all validations when i click close button for 5 to 10 times then this window has been closed.

ssis version is:

Microsoft SQL Server Integration Services Designer
Version 10.50.1600.1

is their any changes happend in properties i.e., LocaleId,LoggingMode etc.,   ?, how to know what change is happend in my package  

---

karteek_miryala

Answer 4

I believe something on the machine changed e.g. a SP or CU was badly applied or another piece of software installed.

The fix must be in doing this

• Open the command prompt
• Navigate to C:\Program Files\Microsoft SQL Server\100\DTS\Binn   
• Run C:\Program Files\Microsoft SQL Server\100\DTS\Binn>regsvr32 dts.dll
  

---

Arthur My Blog

Answer 5

What would be the filename/dll to run for SQL Server 2012?  I do not see regsvr32.dll.

I'm having the same issue.  Have an SSIS package that takes a very long time to load, as it is going through all sorts of Validation checks and verifying all the OLE DB connections, etc ... then when it is finished with that, I have this popup error message and I have to close it down numerous times (once for every OLE DB connection that exists in the package I suppose.)

Here is a visual of the contents of this one particular package

Answer 6

Hi - I am also having the exact same issue as you with same version.  Did you find a resolution?  If so, please share as I also can not find the file as per Arthur's suggestion.....

---

Jenna G

Answer 7

Hi we just experienced the same issue on one of our Dev machines after patches were applied. The fix mentioned above worked like a charm thanks!

For the guys that cant find the file it is sitting in the 110 folder and not the 100 folder. I.e.

Navigate to C:\Program Files\Microsoft SQL Server\110\DTS\Binn  

Thanks

Answer 8

Hi - I am also having the exact same issue as you with same version.
The fix mentioned above worked like a charm thanks!

• Open the command prompt
• Navigate to C:\Program Files\Microsoft SQL Server\110\DTS\Binn    
• Run C:\Program Files\Microsoft SQL Server\100\DTS\Binn>regsvr32 dts.dll

Thanks

---

Developer

Answer 9

I am getting the same error.  The suggested fix didn't work:

• Open the command prompt
• Navigate to C:\Program Files\Microsoft SQL Server\110\DTS\Binn    
• Run C:\Program Files\Microsoft SQL Server\100\DTS\Binn>regsvr32 dts.dll

In my case it is in 120 directory for SQL Server 2014, not 100.  But still didn't work.

It turns out the DTSX package does connection validation when I opened it.  It got hung up when the destination database (Oracle) was taking more than five minutes to log in.   I tested it by logging in directly with Oracle's SQL Developer and thus bypass SSIS.   The username and password was confirmed to be correct.  I set the Data Flow Task's DelayValidtion property to False so at least I can work on it offline until the Oracle DBA fixes the issue.