error while executing job on Sql Server Enterprise Manager

kokilatejas

Executed as user: SYSTEM. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: Copy Data from dist_up.dbf to dbo.dist_up
Step DTSRun OnError: Step,
Error = -2147217865 (80040E37) Error string: [Microsoft][ODBC Visual FoxPro Driver]File 'dist_up.dbf' does not exist.
Error source: Microsoft OLE DB Provider for ODBC Drivers Help file:
Help context: 0 Error Detail Records: Error: -2147217865 (80040E37); Provider Error: 173 (AD)
Error string: [Microsoft][ODBC Visual FoxPro Driver]File 'dist_up.dbf' does not exist.
Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0
DTSRun OnFinish: Copy Data from dist_up to dbo.dist_up Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.

anyone know because if i execute this job with the Schedule package it
dont work but when i execute manually it works ?

This works on our local server because we r using the application and database server as one system but when i do it on the server it s not working we have application and database server as two different system and a folder from app server is used as a mapped drive to database server and the .dbf file is placed in that folder.

pls help me ...