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

harinathu 6 Reputation points
2020-09-10T16:31:14.433+00:00

hi I have one doubt in ssis

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-11T06:28:28.097+00:00

    Hi @harinathu ,

    Please check if you set ODBC connection correctly.

    The following links will be helpful:

    Connect to a PostgreSQL Data Source (SQL Server Import and Export Wizard)

    SSIS ODBC Connection to PostgreSQL - Unable to cast COM object of type error

    Best Regards,
    Mona


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Olaf Helper 42,761 Reputation points
    2020-09-11T07:30:44.52+00:00

    Attunity.IntegrationServices.DataFlowUI.ODBCUI.IAttunityConnectionODBC

    Attunity & PostgreSQL? I wonder, because in SSIS Attunity is an Enterprise feature and this for Oracle connections, see
    Microsoft Connectors for Oracle and Teradata by Attunity for Integration Services (SSIS)

    0 comments No comments