Unable to cast COM object of type error using SSIS ODBC Connection to PostgreS

• asrinu13

  Say Hey Kid

  Points: 709

  More actions

  September 10, 2020 at 4:34 pm

  #3787610

  how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL

  I want load data from postgres to sql server using ssis package .

  In ssis solution I have 50 plus dft for loading data

  from postgres to sql server .

  source is postgre connecting using odbc connection

  and destination using oledbdestination task.

  here out of 50 Plus task, two tasks are getting errors

  Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass' to interface type 'Attunity.IntegrationServices.DataFlowUI.ODBCUI.IAttunityConnectionODBC'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{56CE493E-D855-4BF3-9E13-F807CD43C704}' failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)). (Microsoft Visual Studio)

  if i change connection for those 2 odbc to ado.net connection then its working fine.

  here if i change connnection from odbc to adonet connection then need to change datatype conversion and entire design will change.

  actually all tasks are working fine since 6 month suddenly its getting error .after that those 2 tasks are not working .

  I want avoid this error using odbc connection .

  could you please tell me how avoid this error in ssis package.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 11, 2020 at 5:10 pm

  #3787966

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.