468,242 Members | 1,487 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

error while executing job on Sql Server Enterprise Manager

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 ...
Sep 1 '08 #1
0 823

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Taishi | last post: by
5 posts views Thread by Dave | last post: by
2 posts views Thread by Taishi | last post: by
2 posts views Thread by thersitz | last post: by
3 posts views Thread by vovan | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.