Cannot Access Oracle from Visual Studio 2019 (SSIS component)

Question

Hello,

I am using SSIS component of Visual Studio 2019 to connect to Oracle 12 server and I am getting below errors:

Below are the things I tried :

1) Using ODBC Connector

I was able to connect to Oracle using ODBC in the past by getting past below warning. I was able to test the connection. But, when I tried to ust it in ODBC source, I am getting below error:

TITLE: Microsoft Visual Studio

Exception from HRESULT: 0xC0014020
Error at Data Flow Task [ODBC Source [17]]: SQLSTATE: HY000, Message: [Microsoft][ODBC Oracle Wire Protocol driver]The DataDirect product you are attempting to access has been provided to you by Microsoft for exclusive use with Microsoft Products. You are not licensed to use this product with any application other than Microsoft Products. If you would like to purchase this product for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com ;

---

BUTTONS:

OK

2) Using Oracle Source

I installed and tried using Oracle source as well and it is giving me below error:

TITLE: Microsoft Visual Studio

Could not load file or assembly 'Microsoft.DataWarehouse, Version=15.21.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

---

BUTTONS:

OK

3) Using OLEDB Source

I tried using Oracle Provider for OLEDB to connect to oracle database but not able to get it working. Everytime, I added the server, Username and password and click on test connection, it crashed.

I have already installed Microsoft Oracle Connector for SQL Server 2019 and SQL Server Integration Services Projects by following below link.

https://developercommunity.visualstudio.com/t/could-not-load-file-or-assembly-microsoftdatawareh/745991

Will anyone please let me know what I am missing? Thanks.

Answer 1

Hi @Ashutosh Atre ,

What's your version of the SSIS extension?

Try to install the newest version here.

SQL Server Integration Services Projects

Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

Version support
The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:

Since SQL Server 2019 CU1
SQL Server Data Tools (SSDT) 15.9.3 or later for Visual Studio 2017
Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019

Please also check the official documentation for details.

oracle-connection-manager

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.