I have a .bat file which truncates a table and runs bcp to import a text file. The text file is on a separate server. When I run the .bat file via the sql server agent, it gives the error message "Error unable to open bcp host data-file" (even though I have hard coded the server,dir path)
However, when I run the .bat file on its own (ie outside the sql server agent) it works.
The .bat file resides on the same box as the sql server 2000 db.
I would appreciate it if someone could tell me what I am doing wrong.