Why can't I BCP a Unix file into SQL Server? I get UNEXPECTED EOF messages.

A. This is because UNIX files use just a linefeed (LF, 0x0A) as arecord terminator. NT used a carriage return plus linefeed (CR+LF, 0x0D0A). TheBCP N character resolves to CR+LF.

You have to reformat the file using a tool like AWK/SED/PERL to convert thereformat the 0x0D character to 0x0D0A