Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Job failing, but dts package is successful

Author  Topic 

ninel
Posting Yak Master

141 Posts

Posted - 2006-07-03 : 19:07:18
I have a dts package that is scheduled as a job. This job is created under the admin ownership.
The job is failing even when I log into the server as an admin and start(execute) the job. If I execute the dts package itself it runs successfully.

Any ideas why this may be?
Thanks,
Ninel

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-03 : 21:09:33
what's the error message? check logs, like event logs, sqlserver logs, job history

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -