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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-12 : 09:26:37
|
| Ferdie writes "I have a job executing a dts package every minute. The dts package does a select and insert statement. The problem is that there are times when it just seems to run forever. (not ending).I already put 600 in the connection timeout propoerty of the connection still no effect.Pls. advise.Thanks in advance." |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-12 : 13:57:45
|
quote:
I already put 600 in the connection timeout propoerty of the connection still no effect
It's possible that your DTS package is looping or just taking exceedingly long amounts of time to execute. Is there a single dts package it freezes on all the time?-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
Endless Jobs