I have a task that takes a long time to run. I run it in the middle of
the night but it takes approx 2:45 mins to run. A DTS Win32 Process
task has a timeout parameter which is limited to 9999 seconds (2:46:39).
This cause some problems when the step does not complet on time. Is
there anyway to push it up to 3hrs (10800 seconds)? I have looked at
the tables in msdb but the package steps are a binary object in the
database. I looked at the structured storage file but that is nearly
binary also.

Any clues as to how to extend the timeout of the step??

thanks

Mike Mattix

Not sure I understand. What task? I have tasks (datapumps) which take > 1
day to complete (13GB over a 256 line)


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike Mattix" <david.m.mattix (AT) cpkelco (DOT) dot.com> wrote

On Thu, 8 Apr 2004 20:14:27 +0100, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:

top posting corrected...

Maybe he has an older version of SQL Server??? I know there are
changes from 6.0 through 2000 that could cause similar issues. I
don't know if there was a change in time to complete a task.

In article <1kkb70dn52cop2li8l0oqfris7teso3et1 (AT) 4ax (DOT) com>, dtj (AT) comcast (DOT) net
says...
to use the timeout feature it seems to be limited to 9999 seconds. What
I want to know is if you can get around this limitation.

thanks

Mike Mattix

Ahhhhhhh are you referring to the GUI

"Command Timeout"?

This is probably a limitation o f the GUI rather like the MAX errors it
allows. Try setting in code.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike Mattix" <david.m.mattix (AT) cpkelco (DOT) dot.com> wrote