Problem with ROWTERMINATOR

I am trying to import data from the text file using BULK INSERT command.

BULK INSERT test.s1_test

FROM 'D:\s1.txt'

WITH

(

CODEPAGE = 1250,

FIELDTERMINATOR = '|',

FIRSTROW = 2,

ROWTERMINATOR = '|\r\n'

)

In the text file in the end of each row is symbol which looks like a square - you can see it here

If I use rowterminator '|\n' of '|\r\n', 0 row(s) affected.

Please, can you help me?

hi,

are you sure it's a CR + LF carachter?

it this is the case, data should show it, but your pic does not..

open it with a hex editor...

regards