Results 1 to 2 of 2

Thread: BCP Error

  1. #1
    Join Date
    Jul 2003

    Unanswered: BCP Error

    Hi I need to create a trigger on a table which bcps the table out to a flat fine. I am getting the error "Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file"
    Although if I run the bcp command separately I do not get this error and the command runs successfully. I am using the Exec Master..xp_cmdshell command.

    Please advice.


  2. #2
    Join Date
    Jul 2003
    The Dark Planet
    Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file"

    this error occurs when you give the output path as a directory which does not exist. i.e. you give the path as C:\enigma\enigma.txt even though the directory enigma does not exist on your PC. Create the directory and reissue the command. The BCP command only creates a data file ... not the directory

Posting Permissions

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