none
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

    Friday, June 08, 2012 6:33 AM

Answers

  • 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

    • Proposed as answer by Eileen Zhao Monday, June 11, 2012 7:40 AM
    • Marked as answer by Eileen Zhao Thursday, June 14, 2012 1:44 PM
    Friday, June 08, 2012 12:56 PM
    Moderator

All replies

  • 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

    Friday, June 08, 2012 8:00 AM
    Moderator
  • 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:simonlv@live.cn Skype:simonlvpin

    Friday, June 08, 2012 10:16 AM
  • 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



    Friday, June 08, 2012 10:44 AM
  • 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

    • Proposed as answer by Eileen Zhao Monday, June 11, 2012 7:40 AM
    • Marked as answer by Eileen Zhao Thursday, June 14, 2012 1:44 PM
    Friday, June 08, 2012 12:56 PM
    Moderator
  • 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

    Tuesday, June 11, 2013 6:06 PM
  • 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

    Monday, September 16, 2013 8:59 PM
  • 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

    Thursday, March 19, 2015 8:10 AM
  • 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

    Wednesday, February 10, 2016 3:34 PM
  • 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.

     


    Monday, July 25, 2016 5:40 PM