Search code examples
sql-serverssisetlbidsscript-task

What can be the resolution of Query timeout expired issue

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

Solution

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