473,320 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1655

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Nick LP | last post by:
I have .Net 2003 EA. When I create a simple Windows Form, set a breakpoint, and run it by clicking on "Debug/Start", the debugger hangs. I then have to get out of VS 2003 .Net by using the task...
3
by: Selden McCabe | last post by:
Has anybody experienced this problem? I have a solution that consists of 6 or 7 projects. Every so often (2 or 3 times a week) when I click Run, everything builds seemingly OK, but then, just when...
4
by: Kris | last post by:
I have a Windows Service in C# talking to a serial port and using Remoting. It also uses several COM objects. On customer's computer the service will occassionally hang somewhere - the service...
10
by: Tomas Vera | last post by:
Hello All, I'ma having trouble getting GetCurrentProcess() to work properly. What I'm trying to accomplish is list all running processes. But my call get GetProcesses() hangs. While testing...
3
by: JTF | last post by:
Whenever I start an application from ASP.NET, the exe hangs, with Task manager showing no cpu time. Every exe I've tried hangs in the same way (notepad, cmd, ms access). What runs is a .net exe...
18
by: Wiktor Zychla [C# MVP] | last post by:
Following code was supposed to sort an ArrayList of strings while keeping one "fixed" element at the last position. However, the code hangs in .NET 1.1. I think that answering these questions...
4
by: prateekbaxi | last post by:
Hi, I am developing a Multithreaded Server based Task Scheduler wich runs on the server and informs all the connected client when a particular schedule occurs to do the assigned task. ...
6
by: Alexander Widera | last post by:
hello, if i start a program (an exe-file) with Process.Start(...) I don't have the required permissions that the programm needs (i could start the programm but the program needs special rights)....
0
by: jeff.dyke | last post by:
I am using ftplib in some code that does exactly what you would expect. It ftp's files. Its running inside a service running on windows xp and windows 2003 servers, approximately 20 installations...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.