question

samnick-7321 avatar image
0 Votes"
samnick-7321 asked Monalv-msft edited

Query Timeout Expired via SQL Agent

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @samnick-7321 ,

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.




viewhistory.png (10.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Hi @Monalv-msft ,

The setting within the package is set to -1 for Concurrent executables.
74866-image.png


74904-image.png


0 Votes 0 ·
image.png (130.4 KiB)
image.png (390.0 KiB)

Hi @samnick-7321 ,

A very simple task, but there are around 30 such DF's in the graph.

May I know if you can divide the 30 such DF's into 2 ssis packages?

Best regards,
Mona

0 Votes 0 ·