none
Row Terminator Error

    Question

  •  

    I don't understand why the row terminator isn't working?  Please give insights in to following error message. 

     

    The data file looks like this -- data.txt

    01/31/07þ005002892Aþ891007967Bþ066106þJACKS DRAW UNIT 5 FT UNþ04þ01þAG01þ11/30/06þ570.96þ710.27þ1.244þ4241.04þ71.37þ530.13þEþ14094528

     

     

    BULK INSERT WEXPRO_RMS_DATA.dbo.RMS_DATA

    FROM 'C:\Mike\MAIN_DATABASES\RMS_DATA.txt'

    WITH

    (

    CHECK_CONSTRAINTS,

    DATAFILETYPE = 'char',

    FIELDTERMINATOR = 'þ',

    ROWTERMINATOR = '\n'

    )

    GO

     

    The Error I'm getting is as follows --

    Msg 4866, Level 16, State 1, Procedure sp_InsertData, Line 5

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

     

    Thursday, December 06, 2007 1:58 PM

All replies

  • I'm still not able to get this code to work -- however, I've verified the end or row character in the .txt file is the NL new line feed character; Hex 0A.  How do I tell SQL to recognize that character?  Any help is appreciated.

    Friday, December 07, 2007 4:01 PM