469,927 Members | 1,877 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

DTS Job hangs on 2nd DTS Task

I have a strange SQL Server 2000 DTS problem. I have a DTS Package
that has three tasks in it. The first task is an Execute SQL Task that
writes an entry to a log table, truncates a different table and then
writes another entry to the log table to say it's done truncating. The
second task is a Datapump task. This connects to an Oracle database
and pumps data into a SQL Server table. Then the third task is another
Execute SQL Server task that just writes to the log table saying
everything is done and inserts the time.
The problem I'm having is that when it is scheduled as a job, it will
hang after the first step. I am able to execute the package manually
from the server with no problems whatsoever. It completes in maybe 20
seconds. When scheduled as a job, it runs and runs and runs. I have
let it run for over 30 minutes and finally had to kill it. Here are
some details:
1. If I delete the first task(the first Execute SQL Task) from the
package and then schedule it as a job, it runs fine.
2. If I delete the datapump task and just have the two Execute SQL
tasks and schedule it as a job, that will run fine too.
3. It will hang whether I set the workflow to run the datapump on
completion or on success of the first task.
4. I set the owner of the job to sa.
5. I am pumping the data into a different SQL Server than the server
the job is running on. But I get the same results if I try to run it
to the SQL Server that the job runs on.

I know all of these kinds of things usually end up being some kind of
permissions thing, but I don't think it is that since it will run if
the first task is removed or if the second task is removed. I'm at a
loss, though. Any suggestions would be greatly appreciated. Thanks!

Jul 20 '05 #1
0 1554

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nick LP | last post: by
3 posts views Thread by Selden McCabe | last post: by
4 posts views Thread by Kris | last post: by
10 posts views Thread by Tomas Vera | last post: by
3 posts views Thread by JTF | last post: by
4 posts views Thread by prateekbaxi | last post: by
6 posts views Thread by Alexander Widera | last post: by
reply views Thread by jeff.dyke | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.