Post reply

Bulk Insert - ROWTERMINATOR value

  • July 2, 2004 at 7:37 am

    #88156

    Hi

    My Bulk Insert fails because I'm attempting to load a file from Unix where the end-of-line character is composed of '0A' (LF) not '0D0A' (CRLF) as in Windows, and my ROWTERMINATOR = \n (which presumably expects '0D0A').

    Is it possible to specify value of ROWTERMINATOR to be an '0A' or LF character?

  • July 5, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • July 9, 2004 at 10:22 am

    #514133

    Hi-

    We just had a similar problem and found a good solution here:

    http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1672&threadid=100229

    You might have to be a subscriber to make that link work but basically it says that the \n is composed of \r\l (little r little ell).

    So try the \l and let us know.

    Richard

  • July 11, 2004 at 9:58 pm

    #514226

    I experimented with various suggested options and the one which worked was by specifying ROWTERMINATOR='char(10)'.

    CHAR(10) equates to the Line Feed character. Only the t, n, r, \, and 0 characters work with the backslash escape character to produce a control character. So I'm afraid \l (little ell) doesn't work.

    The the URL in your reply was very useful.

    Many thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply