Query Timeout Expired via SQL Agent

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

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 ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 questions
0 comments

1 answer

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

    Hi @sam nick ,

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

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

    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.