"Unable to open bcp host data-file"

• AMOL DASHRATH THOMBRE

  Grasshopper

  Points: 17

  More actions

  January 19, 2009 at 4:08 am

  #72367

  hi

  friends

  i am facing a problem while reading data from text file into a table using

  BCP utility,it gives a error "Unable to open bcp host data-file"

  please somebody help me resolve this error.

  thanks

  AMOL.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  January 19, 2009 at 4:43 am

  #929104

  First you need to search this forum for "Unable to open bcp host data-file".

  If any of the topics will not resolve your problem then give more details - the way you asked there could no be any reasonable answer.

  _____________
  Code for TallyGenerator

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 19, 2009 at 4:50 am

  #929108

  Can provide answer to following:

  1. what is the command you used?

  2. where is the file located?

  3. Is your SQL server local or remote?

  -Vikas Bindra