Microsoft SSIS - Issues switching from attunity driver to new Microsoft Oracle Connector v1.3
First some facts :
I'm facing some issues when trying to use the Microsoft Oracle Connector v1.3 in SSIS packages. The servers at the company I'm working for are being migrated to SQL 2022, so the previously used attunity driver is now obsolete.
The Oracle driver from Microsoft was deployed on our workstations and now everytime I want to open the Oracle source on the data flow part of the package I get this message (The connection manager was set with Attunity driver):
If I try to create another Oracle connection manager, using this Conn Manager type :
Once I click on test connection the wizard window just close, without any error
I have no admin rights on my WS so I tried several combination of tools / versions and could not achieve to find the good one.
I even tried to downgrade Data Tools as I could see that Oracle driver is not supported in newer ones, but with no success.
At the moment my components versions are : Microsoft Visual Studio Professional 2019 Version 16.11.33 SQL Server Data Tools 16.0.62205.05200 SQL Server Integration Services 15.0.1900.73
Hoping that somebody here may have had the same issue, and so, some advice
Thanks in advance
Solved by :
- Making a clean install of VS 2019
- Making a clean install of SSIS for VS 4.6
- Installing Microsoft Oracle Connector for SSIS 1.3 for SQL2022
- Transpose Hierarchical Table based on leaf nodes with nodes as first column
- Comparisons using EXTRACT YEAR not working
- Oracle Analytics - partitions and ordering of sql queries
- Selecting a sequence NEXTVAL for multiple rows
- Oracle procedure error: Expected UDT got CHAR
- Transform Travel Table - SQL
- Get lowercase letters from Oracle 10g columns
- pull access denied for container-registry.oracle.com/database/enterprise
- USE database_name command alternative for Oracle
- How to return columns from dynamic SQL in Python console
- How to determine if and which index is being used in oracle
- How to raise Oracle PL/SQL exceptions from Python
- sql extraction of identification numbers
- Oracle Database: Find Missing Indexes for Performance tuning
- difference between 'natural full outer join' and 'full outer join'
- SQL query giving error msg not enough values
- Unique Constraint violation
- Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-00302: component 'GET_EMP_INFO' must be declared"
- ORA-00001: uniqueness constraint violated
- Unable to set CLASSPATH with confluent CLI : java.sql.SQLException: No suitable driver found for jdbc:oracle:thin
- In an oracle RAC setup, can a single transaction be assured to be executed on a single node?
- Django: how to see the SQL query when running tests?
- Multiple Passwords for Multiple Schemas in single connection
- Get the resultset of any SQL cursor as XML with column names as attribute without using XSLT in Oracle
- Get UDT type name inside of its body in Oracle 19c
- Oracle regexp_replace
- Extracting data from an Oracle DB on python. Facing issues with the multibyte characters
- Setting report column to YES or NO based on date - Oracle SQL
- SQL script called from Jenkins Pipeline does not output error or correct exit code
- Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field