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 ...

[kenobewan]

The first thing to do is look at your connection string. This doesn't seem to be an IIS problem.

[kokilatejas]

The connection string is pointing to database server.

[kenobewan]

The connection string is pointing to database server.

Your error message appears to disagree, "File 'dist_up.dbf' does not exist".