rowterminator for bulk insert ?

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  August 13, 2008 at 4:46 pm

  #196973

  We have a file that was generated from Unix.

  Windows standard row terminator is char(13) + char(10)

  Unix, however, is just char(10)

  Bulk insert accepts Windows defaults, of course. What should I specify for Rowterminator option in Bulk Insert command for a file generated in Unix ? B.O.L. does not give any idea for it.

  Thanks.

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  August 13, 2008 at 4:55 pm

  #857776

  If memory serves, it used to be: /n

  ---

  And then again, I might be wrong ...
  David Webb