File exported thru BCP adding blank line at the end

• yoginraval

  Old Hand

  Points: 394

  More actions

  May 14, 2009 at 3:38 pm

  #93563

  Hi,

  I'm using BCP command to export the data of a table to flat file. The file is getting created fine with all the data, but it is adding an extra blank line at the end of the file. Is there is any way to avoid creation of blank line? Following is the BCP command I'm using

  BCP

  out -c /U /P /S

  Please let me know if there is anyway to avoid blank line in the end of the exported file. Thanks

• dean.betts

  Valued Member

  Points: 55

  More actions

  November 15, 2012 at 9:22 pm

  #1559600

  Hi,

  had the same problem.

  I had success with a -r option, which basically sets the row termination to nothing.