Datadirect message warning when using Microsoft connector for oracle

user 126 Reputation points
2023-11-24T16:59:03.5266667+00:00

Hi team,

I created an ssis package with data sources (oracle 64 bits using microsoft connector for oracle) and destination (sql server 64 bits). in fact through an sql query I want to export data from an oracle table to an sql server table.

Using visual studio vs2022 64bits 17.6.4 in debug mode, I receive the following warning message:

[Microsoft][ODBC Oracle Wire Protocol driver] The DataDirect product you are attempting to access has been provided to you by Microsft 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.

I made a faultless deployment of the ssis package to sql server for scheduled automatic execution. But when execution is started, I receive the following error:

Executed as user: PC\Administur. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 32-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 10:50:48 Error: 2023-11-23 10:50:48.48 Code: 0xC0014009 Source: Package1 Connection manager "oracle.user" Description: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. End Error Error: 2023-11-23 10:50:48.48 Code: 0xC020801C Source: Data Flow Task ODBC Source [27] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "oracle.user" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2023-11-23 10:50:48.48 Code: 0xC0047017 Source: SSIS.Pipeline Data Flow Task Description: Source ODBC failed validation and returned error code 0xC020801C. End Error Error: 2023-11-23 10:50:48.48 Code: 0xC004700C Source: SSIS.Pipeline Data Flow Task Description: One or more component failed validation. End Error Error: 2023-11-23 10:50:48.50 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:50:48 Finished: 10:50:48 Elapsed: 0.187 seconds. The package execution failed. The step failed.

see here: https://ibb.co/fYDH4G6

My environment:

  • windows server 2019 64 bits version 1809
  • sql server 2019 64 bits RTM 15.0.4335.1 enterprise Edition
  • vs2022 community 64 bits 17.6.4
  • ssis 2022
  • ssdt
  • microsoft connector for oracle
  • Oracle instantclient

can you help me please?

Any help is much appreciated!

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,869 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,315 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,726 Reputation points
    2023-11-24T18:19:24.5466667+00:00

    Hi @user,

    It seems that you used SSIS ODBC Source adapter in the Data Flow Task (DFT). That's why you are getting the following:

    [Microsoft][ODBC Oracle Wire Protocol driver] The DataDirect product you are attempting to access has been provided to you by Microsft for exclusive use with Microsoft Products. ...

    You need to use Oracle Source instead. It shows up in the DFT Toolbox after installation of the Microsoft Connector for Oracle v.1.2

    SSIS Microsoft Connector for Oracle


1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,226 Reputation points
    2023-11-27T02:14:19.69+00:00

    Hi @user,

    The error message is clear that if you are not licensed to use this product with any application other than Microsoft Products.

    To connect to Oracle source in VS2022, you may consider using Microsoft Connector for Oracle.

    After you install the connector, you must restart the SQL Server Integration Service to be sure that the Oracle source and destination can work correctly.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments