Hai,
I'm working with SQL2000 server
and i'm using DTS import.
I have made a schedule package (job) from a DTS.
When i run direct the DTS, there is no problem, it works
But when i run the job, it failed.
But some other jobs to import a DTS there is no problem.
Who can help me.

Jaap wrote:
This will be because of the change in security context and execution
location from you on your machine to the SQL Agent service account on
the server.

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/default...b;en-us;269074)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com