I have a daily text file I recieve that is exported from an SAP system. Some
how SQL text data connection is droping rows when I import the file.

If import the file into XL, I get all the rows. I looked at the file in a
HEX editor and the row delimiter is consistant (CR/LF or OD/OA). The file is
fixed field length.

When I use SQL's Text file (source) data connection and CR/LF, I receive a
message that states: "Can not find the selected row delimiter within the
first 8Kb of data."

It will import if I use LF and the row delimiter but it will drop 1000's of
records.