I have a several DTS packages that contains some tasks and other inner
packages.
Those DTS's are scheduling using the SQL Agent.
Once in some days, one (of those DTS's) stops his run without any error
messege.
Of course the other steps after this step (that was "stuck") are not running
as well hence the workflow is "on success".
When I look at the Package Log of this DTS, it's seems like no "End Time"
and no error at all (take a look on the screen shot attached).
I can’t catch this problem while running the DTS manually.
The problem happens even on a very simple task (like a query that take 30
seconds approx).


Somebody ?

http://www.segment.co.il/dts.jpg



BTW:
WIN2K+sp4
SQL2k+sp3

I've seen a similiar problem once, in our case the symptoms were
precisely the same-- a job would fail intermittently and wouldn't work
again until the server was rebooted. It turned out to be some MAPI
setting or smt related b/c removing the sendmail task that executed at
the end of the job fixed the problem. Never figured out exactly what
was wrong ... but it hasn't broken yet (fingers crossed) so long as we
don't use the sendmail task. (xp_sendmail from w/in a proc was used
instead)

Well, our DTS's are very simple, just SQL query tasks.
No sendmail or something....


"urchin" wrote: