• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5097
  • Last Modified:

SSIS how to set query timeout

I am running an stored proc using execute sql task. The package is set to run automatically using sql Agent. Sometimes I see query timeout error wen the package is run. How do I set the query time out? On the properties window It show 0 for timeout.

I am also running another sproc inside a script task (c# script) in the same package. How do I set the query time out for running this sproc in the script task?

Thanks.
0
patd1
Asked:
patd1
1 Solution
 
Eugene ZCommented:
what is your sql server version\edition \sp ? make sure sp is fresh?

/from
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/241ad5c5-e72c-4f59-8b19-cb944085a3a7 /

please clarify what one?
---

There are three timeouts:

General
Connect
Command

General should be the overall timeout for the connection.  Connect should be just for the connection.  If the connection hasn't been established by the timeout (or the default), it will stop trying to connect.  Command timeout is likely the timeout SSIS will wait for a command to complete

--
there is an example how to set

http://forums.teradata.com/forum/connectivity/sql-server-integration-services-ssis-and-timeout-errors

Switch to "Data Flow" tab (vs. Control Flow) and select the DataReader source. The Properties window will show CommandTimeout at the very top; it is set to 30 seconds by default. .

---
1

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now