Glenn,

If those : characters are in the file you need to account for them. Are you sure the last line in the file meets the same spec as all the other rows? Use hexedit to verify it. You also have to make sure that no field in the file content actually exceeds the space allocated in the field. If you temporarily set your batchsize to 1 you should be able to tell which line is erroring out.

But this is one of the hardest things to debug because of the "extremely helpful" (marked sarcasm) error messages.

>I replaced the format file with your example and now I am getting the dreaded
>"Server: Msg 4832, Level 16, State 1, Line 1
>Bulk Insert: Unexpected end-of-file (EOF) encountered in data file."
>
>I have re-read all the documentation on bulk insert, using format file and still no cigar:<