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 ?