I have a simple DTS to pull data from Oracle 8i table to SQL 7.0 table. This
runs without any issues when it execute intractively but when it schedule it
doesn't fail but hangs. The status shows "executing job step 1" and need to
kill the job. I can not use logging because it say package logging only
allows in SQL server 2000 and the erroe log does not have any thing. Is there
any way to trace this issue, did anybody know how to fix this. Please help.

Thanks in advance.