Connection may not be configured correctly or you may not have the right permissions on this connection

I have a package in SSIS and it only contains an Execute SQL Task with a connection to Netezza. So the provider to connect to Netezza that I use is NZOLEDB. When I run it locally on my machine, it runs smoothly and without error. However, when I deploy it in SQL Server and execute it with a Server Agent, I get 2 errors:

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

2) SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Netezza OLE DB Provider" Hresult: 0x80004005 Description: "Client unable to establish connection".

In the job step, I went to Configuration > Connection Managers and manually added in the value for the password to connect to Netezza. That still didn't help.

Any help would be great, thanks!