Something isn't configured correctly or accessible from the
server. When you run DTS manually, it runs from the PC where
it's executed and under the security context of the person
executing the package. When you schedule it to run in a job,
it runs from the server and under the security context of
SQL Agent service account (or the proxy account if owned by
a non-sysadmin). So everything is configured correctly on
your PC and using your security credentials but not on the
server using the SQL Agent credentials.
Refer to the following for more information:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On Wed, 3 Sep 2003 11:14:42 -0300, "Adriano Galle Dal Prá"
<dalpra (AT) cwb (DOT) palm.com.br> wrote:

Hi,

Have you checked whether you had all the SQL Server 2000 service packs?
The new one is SP3a. Might be a reason for failing....

Dip


--
Posted via http://dbforums.com