Bulk INsert with {LF} Row Delimiter

• ddaughtery

  SSC Enthusiast

  Points: 190

  More actions

  February 10, 2009 at 9:58 am

  #383907

  I need to write a bulk insert statement with {LF} as the row delimiter and a "," as the column delimeter. Below is what I have

  BULK INSERT CaseLevelData.dbo.medpar2007_hosp_costedcsv

  FROM 'D:\medpar2007_hosp_costed.txt'

  WITH

  (FIELDTERMINATOR = '","',

  ROWTERMINATOR = '')

  GO

  But I get the following error:

  The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.

  Am I using the correct ROWTERMINATOR in the statement?

• Bruce W Cassidy

  SSChampion

  Points: 12668

  More actions

  February 10, 2009 at 1:20 pm

  #941592

  [font="Verdana"]have you tried using char(10) as the row terminator?[/font]