0

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

Hadi
  • 36,233
  • 13
  • 65
  • 124
BlackCat
  • 1,932
  • 3
  • 19
  • 47
  • You need to provide more details, what is the script task code? why you are assuming that it is thrown from script task? – Hadi Jan 29 '18 at 13:21
  • What is your script task doing? Are you calling a web service? – holder Jan 29 '18 at 13:55
  • The first suggestion I have to resolve this issue is for you to provide some details so we have a chance at solving the real issue. At this point we are left to randomly speculate why this happens. – Sean Lange Jan 29 '18 at 14:42
  • 1
    Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. – Tab Alleman Jan 29 '18 at 15:13
  • @TabAlleman the OP didn't logged in after he asked the question. I think that it is good to give him a chance to edit the question. – Hadi Jan 29 '18 at 20:42
  • That's fine, but https://meta.stackexchange.com/a/98026/272049 – Tab Alleman Jan 29 '18 at 21:21
  • - I am not assuming.It is showing error on the script task. – BlackCat Jan 30 '18 at 06:06
  • In the scrip task, there is simple if else logic which set a variable upon checking some files exists or not in folder path. – BlackCat Jan 30 '18 at 06:11
  • Also, I am using Database connection and Sql Command in it – BlackCat Jan 30 '18 at 06:20
  • @BlackCat, you need to post more details about what your script task is doing. First you say it's checking to see if files exist, then you say you're using a Database connection and SQL Command. Our ability to help you varies directly with how much information you provide. – Brian Jan 30 '18 at 21:45

1 Answers1

1

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

Tab Alleman
  • 31,483
  • 7
  • 36
  • 52