DTS_E_OLEDBERROR. Error code: 0x80004005.. Hresult: 0x80004005 Description: Login failed

I am not sure what happened to my OLEDB connection and I am getting the below error when executing the SSIS package from SQL Server Agent Job. However, It works fine when I execute in the Visual Studio or in SSDT.

It is just saying 'Login failed' and not even saying 'Login failed for any particular user'.

Using : SQL Server 2012 R2

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

How can I debug this?