Why do I get an "UNEXPECTED EOF" message in BCP?

Neil Pike

January 24, 2000

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. Basically because the file layout does not match that which you've told BCP.

If you have a native 6.5 format file then make sure you specify the -6 option on the 7.0 version of BCP.

Otherwise, use a hex-editor to open the file and check the layout. Look especially for missing carriage-returns and line-feeds. e.g. UNIX files use just a linefeed (LF, 0x0A) as a record terminator. NT used a carriage return plus linefeed (CR+LF, 0x0D0A).

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like