Problems with BCP

• ulisseslourenco

  SSC-Addicted

  Points: 417

  More actions

  January 13, 2011 at 1:46 pm

  #232208

  Hi guys

  I have a problem with bcp because I am trying to import a csv file, however one row has no newline character and it isn't imported.

  My main problem is bcp command is into VB application and I would like to do how stop importing to avoid problems with custumer registers. Is there some parameter to force or stop an file importation?

  regards

  Ulisses.

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  January 13, 2011 at 4:28 pm

  #1273361

  there is the -m flag for the maximum no of errors before an import is aborted, is that what you want?

  ---------------------------------------------------------------------