What can be the resolution of Query timeout expired issue

Question

I am facing an issue while running SSIS package using Microsoft Visual Studio

Thing is, this issue does not occur all of time.

The error message:

Error: Query timeout expired

N.B: The error occurs in a script task, my guess is, there is a setting where it limits the run time and through errors when it exceeds.

Any suggestion to resolve this scenario is very much appreciated

Answer 1

Increase the timeout on your SQL Command in the script task.