Query Timeout Expired via SQL Agent

Question

Hello,
I am trying load data from a table and upsert into the destination table. A very simple task, but there are around 30 such DF's in the graph. this is a Azure VM with 2017 sql server. Oddly, when i execute the package from within SSIS, i get no errors and it executes perfectly without any issue. But when i run the package via SQl Agent job by scheduling it, the package fails with the below error.

'An error occured with the following error message: "Query timeout expired"

Not sure what else is missing. Any recommendation on where to even begin ?

Answer 1

Hi @sam nick ,

1.Could you please share more error information by clicking View History in Job?

2.Please check if you set Package.MaxConcurrentExecutables Property as -1 in the properties of ssis package.

Best regards,
Mona

---

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

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.