Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: SQL Server Agent

    Hi

    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.

    Thanks for your help

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    your sql server account has different rights than you do (if you have an explicit account, local or domain, not System Account).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •