I've changed an SSIS package to use a 64-bit ODBC connection instead of 32-bit.
After deployment it works fine when executing the package but when running a SQL Server Agent job with the package it fails with:
An ODBC Error -1 has occurred
There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server
The AcquireConnection call to the connection manager Athena West-1 64-bit failed with error code 0xC0014009.
What is the reason for this error?