SSIS job timeout and component not executed

Question

Hello,
We have a job based on ssis package which run every xx minutes. Randomly, the job timeout and after checking logs, we see that there is nothing after the truncation component (simple SQL task)

the package end like this:

we don't understand why the job can't execute our last component (simple sql task). There is no particular lock, and this happens randomly.

Thanks for help
regards

Answer 1

Hi @A B ,

As said in the documentation truncate-table-transact-sql, TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable.

Please double check if it is a permission issue.

You may also delete the package in SSIS catalog and then re-deploy it for a try.

Regards，

Zoe Hui

---

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

Answer 2

Dear @ZoeHui-MSFT

thank you for your quick reply.
Ok, I will try to delette and reload package

but the problem not seems coming from the truncation (which seems ok), but after, as the last component is never executed
regards

Answer 3

Hi @A B ,

I would suggest switching to Verbose logging instead of Basic.
It may reveal some additional information.