shecule job to run a dts package failed.

#1

I create a DTS package to transfer data between an oracle and a sql2000
servers. When I manually exute the package, it ran through successfully.
However, when I schedule it to a job, it failed to run. What could be the
problem?

thanks

#2

http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a
Scheduled Job

--
Andrew J. Kelly SQL MVP

"Fei" <Fei (AT) discussions (DOT) microsoft.com> wrote

Quote:

I create a DTS package to transfer data between an oracle and a sql2000
servers. When I manually exute the package, it ran through successfully.
However, when I schedule it to a job, it failed to run. What could be the
problem?

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

shecule job to run a dts package failed.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

shecule job to run a dts package failed. - 10-13-2005 , 12:14 PM

Re: shecule job to run a dts package failed. - 10-13-2005 , 12:36 PM