SSIS Unexpected Termination While running a packages through SQL Job

Question

Hi Everyone,

support required for the below error

My SSIS package execution failed with unexpected termination while running through SQL jobs.

Package Purpose:

To Load multiple .xlsx files to SQL tables using Foreach Loop Container.

Sometime job gets succeeded and all files being loaded to table. most of the execution failed with unexpected termination.

All the time package stuck while Data Flow task: Prepare for execute phase is beginning.

However, same package works perfectly when I run from visual studio.

Thanks,

Answer 1

Hi @Raj Kumar A,

The error message is a bit general for us to narrow down the issue.

How do you design the data flow? Please make sure you have set the validation delay on the task level?

Could you please try to re-deploy the package and run it manually in agent job?

And also make sure you have full access to the source and destination.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

This could be related to your antivirus as explained here: https://youtu.be/Jg7stUhfr-s?si=1lMa_XZ6pfn7P_5L