When I schedule a job, when it runs it calls a .dtsx package. i fails with the following error:
Connection manager "<name>" Description: SSIS Error Code DTS_E_OLEDBERROR.
Hresult: 0x80040E4D Description: "Login failed for user '<user>'.".
Can anyone help me how to approach resolving this error