I have a problem with SQL server Job . Job keep failing while executing package . Job and Package on Same server.
If you run package from MANAGEMENT STUDIO from the same server , its works fine.
"DestinationDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D
Description: "Login failed for user 'DOMAIN\SERVER$'.". End Error Error: 2015-05-26 11:27:37.65 Code: 0xC00291EC
Source: EST_NameOfTASK Execute SQL Task
Description: Failed to acquire connection "DBnameDestination".
Connection may not be configured correctly or you may not have the right permissions on this connection. End Error
DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:27:36 Finished: 11:27:37 Elapsed: 1.328 seconds. The package execution failed. The step failed.