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
- I am updating table's column values with UPDATE and SELECT statement. But its not working
- I want to insert data into a column from its own table data?
- How to resolve ORA 00936 Missing Expression Error?
- Cypress 10 and connecting to an Oracle database
- Oracle SQL - Select oldest of 3 dates, but ignore NULLs
- Sleeping for a random amount of time in a stored procedure
- Keep getting error: PLS-00103: Encountered the symbol "CREATE"
- How to utilize WebDev.WebServer.exe (VS Web Server) in x64?
- How to modify query converting DATEDIFF to Oracle accepted syntax?
- Oracle database dependencies in PL/SQL
- In Oracle: How to sort by group/cluster by a column value
- oracle SQL query - add date rows using different date
- Oracle Apex Change date picker format
- Can't login as sysdba in oracle sqlplus
- What is the cause of this problem "IO Error: The Network Adapter could not establish the connection" on Sql Developer?
- Getting error as ORA-01821: date format not recognized in Oracle
- Running a dynamically generated MERGE INTO statement in a loop throws "ORA-01489: result of string concatenation is too long" error
- How to compare two rows column by column?
- Translate excel formulas into SQL query
- Django: how to see the SQL query when running tests?
- ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
- How to partition an oracle table by a date column?
- Oracle 19c :: Failed to set ACL's for specified User
- C# Pass array of objects (UDT) to oracle stored procedure returns exception 'Column contains NULL data' on ExecuteReader
- Selecting from 1 table and put the result into 2 column
- Oracle DBMS_SQL giving ORA-1007 variable not in select list
- Oracle SQL Need to identify distinct PK values where a grouped set contains a specified value in a column
- Can't disable session state protection on Oracle APEX 18.1.0.00.45 for Dynamic Actions updating Page Items
- HIbernate issue with Oracle Trigger for generating id from a sequence
- When do I need to use a semicolon vs a slash in Oracle SQL?