ssis sql agent job error - The process exit code was -1073740791

Question

the job failed without ssis log error found in the ssislog table. it only has the following error in SQL agent job
however, the job is set as daily. and it can ran successfully in the past 3 day. only failed this time without ssis log but the process can't be ended. (don't has end task ssis log)

Message
Executed as user: {sql_agent_job_user_account_id}. The step did not generate any output. The return value was unknown. The process exit code was -1073740791. The step failed.

Answer 1

Hi @nononame2021 ,

The error message is hard for us to narrow down the issue.

You may run a Process Monitor to check if that we could give any lead.

Also you may check the Event Viewer Logs to see if there is any useful information.

Here is a same issueSSIS package fails with error : The step did not generate any output. The return value was unknown, you could take a reference to it.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.