SSIS package with Oracle connections fails running from SQL Job but works from Integration Server

Question

I have developed a SSIS package that uses an Oracle connection.

It works if I run from Visual Studio 2022 and also if I execute the package in the Integration Services Server (Both options at SQL Server machine).

I have created a SQL Job to schedule the execution of this package and I get this error:

Failed to acquire connection "ORACLE_CONNECTION". Connection may not be configured correctly or you may not have the right permissions on this connection.

I run the job step as a proxy with the same credentials as Integration Service run.

As far I know both Visual Studio 2022 and Integration Service runs in 64 bit, but just in case I have also tried to set the Use 32 bit runtime option in step execution options but I got the same error.

Thanks in advance.

Answer 1

I have included the Oracle bin path (in my case C:\Oracle\X64\bin\) in the Path Environment variable and everything works.