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
{count} votes

Your answer

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