Query Timeout Expired via SQL Agent

asked 2021-03-05T05:16:58.16+00:00
sam nick 186 Reputation points

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 ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-03-05T07:37:52.793+00:00
    Monalv-MSFT 5,686 Reputation points

    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,

    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.