SQL Server Agent job fails to run SSIS package, but the package runs fine manually The SQL server is SQL Server 2012. The job has been working for a long time fine. This is the first time when it failed. We haven’t changed anything.
Executed as user: Domain\SQLServiceAcct. Started: 5:36:22 AM Finished: 6:56:31 AM Elapsed: 4809.11 seconds. The package execution failed. The step failed.
Information about the job:
It has a proper SSIS Package Credential (we use the service account as identity) The Job runs as: Proxy SSIS Exec Package source: SSIS Package Store Log on the server: Use Windows Authentication (we use service account) Package: \MSDB\FOO_BAR\name of the job
Is this something to do with the SQL Server agent?