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
- Queue monitoring oracle script
- Date Time Format, Perl Oracle SQL
- Ansible playbook takes forever to execute an Oracle DB query
- Search All Fields In All Tables For A Specific Value (Oracle)
- Returning clause in json_table or skip error on error?
- Find a gap > 10min and select begin/end dates in timestamp logs
- Need to extract value from key-value pair data
- Simple OracleBulkCopy example erroneously prefixes my already qualified target table name with my own schema name
- Parsing JSON with Oracle SQL without knowing incoming field names
- Oracle SQL Developer doesn't start
- Alternatives for IN and NVL operators for classic report query
- List column name for user views in oracle
- Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
- Map table to exactly one of three
- Convert the total amount in words
- Oracle APEX - Create 'Duplicate' Button Next to the Report
- Log SQL parameter values when using spring-boot-starter-data-r2dbc for Oracle database (oracle-r2dbc)
- How do I pass a return code from an Oracle script back to the WINDOWS Batch script which called it?
- How to enter newline character in Oracle?
- Selecting from random column in PL/SQL
- What is the difference between complete refresh and fast refresh in materialized view?
- Split timeperiods by referring dates in another table
- Entity Framework Core automatically inserts double quotes in Oracle database
- How to remove duplicate rows from a join query in oracle?
- Oracle SQL how to get the group by columns along with other selected columns
- I want to choose hiredate between '20-FEB-81' AND '01-MAY-81'
- Access a Method in a PL/SQL Collection of Objects Using a Pipelined function
- How to query based on related tables and grouping the records as per the nearest range values?
- Substring between 2 strings in Oracle SQL
- Data type for encrypted content