Share via

Getting error in SSIS package, using attunity connector

Mathieu Mussler 0 Reputation points
2025-07-17T13:26:19.4+00:00

Hello,

I'm trying to get help on a issue I'm trying to deal with.

Got a new wokstations here, with fresh installed VS, SSIS, MS Oracle connector, etc.

I get to work on SSIS Packages, that intend to extract data from Oracle DBs, using an old attunity connector. Everytime I open a package, this connector appears marked as in default, and if I open it, and try a connection to an up & running db, I get this short message:

User's image

Only workaround is to create another oracle connector, map my packages object to this connector, make my changes, and map back the objects to the previous connector, before the deployment. (Everything runs fine on server side)

package is set to do not save sensitive, target server version is 2019, and set to run in 64 bits.

I tried as many things as possible and running out of ideas. If somebody been there, done that, I'll get any solution with pleasure.

Below are the software versions on my workstation:

Oracle client 21.3 (both x86 and x64 versions installed)

SQL Server Integration Services Oracle Connector version : 16.0.5479 (both x86 and x64 versions installed)

ODBC Driver version : 8.00.02.2219

VS 2022 version : 17.9.5

SSIS version : 16.0.5685.2

SSDT versions : 17.9.55.1 Many thanks in advance

SQL Server Integration Services

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Venkata Ramanamma Uppu (Quadrant Technologies LLC) 0 Reputation points Microsoft External Staff
    2025-11-24T12:25:49.88+00:00

    Hi Mathieu Mussler,

    Thank you for reaching out to Q&A Forum.

    Your errors occur because the old Attunity Oracle connector is not compatible with Oracle Client 19c/21c, which you currently have installed. The connector still loads in Visual Studio but cannot create a real Oracle connection, which causes the 0xC020801C and 0xC0014009 errors.

    The working fix is:

    Uninstall Oracle Client 21c

    Install Oracle Client 12c or 18c (both x86 and x64)

    These are the last versions that fully support Attunity.

    Once you install 12c/18c, the Attunity connection manager will stop showing errors, and preview/test connections will work again. Your server works because it still uses an older Oracle client. If you cannot downgrade, you must switch to the new Microsoft Oracle connector, which supports Oracle 21c.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.