dts - experts please

Hi,
I need some help quite urgently. I have a job which fires off about 10 DTS
packages to run. 2 of these packages are very similar, they basically
import and process about 200,000 rows of data. The total time for all jobs
to run can be up to 2 hours.
My problem is that of the 2 jobs mentioned above, it seems to hang on the
2nd one. When I do a sp_who2, it says the process is updating records,
however it doesn't seem to finish (it was still hanging 24 hours later with
no locks on that process).
If I run the jobs manually (ie: copy/paste the processing part of the logic
into Query Analyzer and run it), then it works fine (and very quickly too -
within a few seconds). I have even tried putting debug code at checkpoints
in code to see where it hangs. However, like I said if I run the code
manually, it completes with success within seconds.
Does DTS have some sort of limit on tasks or timeout? I'm not sure it's a
timeout issue though because I've run the same code on 2 servers (of
different processer specs) and it hangs at the same point. :-(
I have no idea what the problem is and I need a solution quickly. Can
anyone offer any suggestions?
Thank you.Trisha
Specify an output file for the jobs' step to see what happened. Maybe you
have blocks or/and locks on the database.
"trisha" <trisha@.spam.com> wrote in message
news:ev4b46U7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I need some help quite urgently. I have a job which fires off about 10
> DTS packages to run. 2 of these packages are very similar, they basically
> import and process about 200,000 rows of data. The total time for all
> jobs to run can be up to 2 hours.
> My problem is that of the 2 jobs mentioned above, it seems to hang on the
> 2nd one. When I do a sp_who2, it says the process is updating records,
> however it doesn't seem to finish (it was still hanging 24 hours later
> with no locks on that process).
> If I run the jobs manually (ie: copy/paste the processing part of the
> logic into Query Analyzer and run it), then it works fine (and very
> quickly too - within a few seconds). I have even tried putting debug code
> at checkpoints in code to see where it hangs. However, like I said if I
> run the code manually, it completes with success within seconds.
> Does DTS have some sort of limit on tasks or timeout? I'm not sure it's a
> timeout issue though because I've run the same code on 2 servers (of
> different processer specs) and it hangs at the same point. :-(
> I have no idea what the problem is and I need a solution quickly. Can
> anyone offer any suggestions?
> Thank you.
>
>
>|||Hi,
Thanks a lot for your reply.
Yes I have specified an output file, but there is nothing of any help in
there. It just says which steps within the jobs are being performed and
whether they succeeded or failed. My problem is that the job just seems to
hang.
I have done a sp_who2 to make sure there are no blocks on the db, how do I
check if there are any locks?
Any other suggestions if I find there are no locks on my db? :-(
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e%23EB7KZ7FHA.744@.TK2MSFTNGP10.phx.gbl...
> Trisha
> Specify an output file for the jobs' step to see what happened. Maybe you
> have blocks or/and locks on the database.
>
>
>
>
> "trisha" <trisha@.spam.com> wrote in message
> news:ev4b46U7FHA.3660@.TK2MSFTNGP09.phx.gbl...
>