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?