Error 0xC0014009 for a SSIS 2017 package to import data from a SAP HANA 64-bit OBDC source

Question

I'm trying to a SSIS 2017 package that connects a SAP HANA OBDC source.

In the dev machine having Visual Studio and the 32-bit ODBC driver, the package functions without any problems inside VS.
In the prod machine having a system DSN with the installed 64-bit ODBC driver, the package deployed on SSIS catalog goes in error with a such message: Method call AcquireConnection to the connection manager SAP_HANA64 failed with error code 0xC0014009.

Any ideas in order to solve this issue, please? Does it exist another manner to get SAP HANA data without using an ODBC data provider?

Many thanks

Answer 1

Hi @pmscorca ,

In the prod machine having a system DSN with the installed 64-bit ODBC driver, the package deployed on SSIS catalog goes in error with a such message: Method call AcquireConnection to the connection manager SAP_HANA64 failed with error code 0xC0014009.

1. Please set Run64BitRuntime as True in the properties of ssis project.
2. Please uncheck the 32-bit runtime in SSISDB Catalog.

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 2

Hi Mona,

thanks for your reply, but I've already verified the package and deployed it with the right settings.

Answer 3

Hi Mona,
in the prod machine is installed the 64-bit ODBC driver, because the SSIS package has to function with this 64-bit data provider.

Best regards,
Pasquale

Answer 4

Hi @pmscorca ,

Could you please check if the user in ssis catalog has permissions to access the database server in ODBC connection manager?

The following link will be helpful:
SSIS package failed

Best Regards,
Mona