Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Setting Connect Timeout in SSIS Packages

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-03-02 : 12:06:37
Hi everyone,

We have some (2005) packages/jobs that are failing because the Connect Timeout and the Command Timeout values are too low.

usually by increasing those values, the jobs complete successfully.

Just a question: Do you have your timeout values set to 0 (zero) which means the package can run forever?

Thanks for suggestions. John
   

- Advertisement -