We have a job, that contains SSIS packages. It is SQL Server 2005. A dba named xyz created those SSIS packages. It was running fine in the when the job kicks in. However, he left, and the company wanted to change all his ownership from all objects, such as databases, jobs, and maintenance plans ownership to sa.
As we did this, lots of errors came up. Every other job runs fine, only those jobs with SSIS package are failing.
Error is :
Executed as user: Mycompany\sqlagentserviceAccount. Unable to open Step output file. The step failed.
However, the SSIS package was created by the xyz DBA. For troubleshooting we did change the job ownership to xyz dba name, but it still failed.
Any help on how to change the SSIS packages back to his name, or any other tips, would be appreciated.