I've recently been facing this issue where we have almost all the SQL jobs internally calling the SSIS packages fail with the exit code. However, when the same package is executed manually it runs fine. I've tried all that I possibly could but there is nothing that I could think of that might be an issue. I see these jobs failing in these last couple of days only...initially it was running fine. In case if there is anything that you'll can point me out to resolve the issue would be helpful
Server: Windows 2012
Environment: SQL 2012
Package: SSIS Catalog.
Error Msg:
Executed as user: XXX. The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.
Regards,
Feivel