I just tried that and get the same result.

Here is the code for the bulk insert

BULK INSERT Test_Table

FROM 'sourcefolder\filename.txt'

WITH

(

FIELDTERMINATOR = '|',

...

I don't use a format file, it just comes to me as a text file. Unfortunately I don't have any test data it is all real data. I...