Hi all,

I have several DTS jobs running. Most of the times the
jobs runs fine.The main Job of DTS is truncating the
destination tables present in other server and then
copying the data from source in other server.All the jobs
have been schedule to run (some every 15 min, some every
1hr to some once in a week). I noticed that some times
when there is an lock between process/users it fails.
Once the session is killed and the DTS is run manually,
after that it works. But the actual problem arises when
there is no lock detected and the jobs status says
executing but never ends. Many days it works fine but
sometimes continously it gives problems. and when i go and
view history in detail steps it shows successful.

Pls. help me out along with the reason as i am being put
underpressure from the client.
Thanks in Advance