March 20, 2012 at 6:58 am
I'm trying to bcp in data from a text file in unix to my sql server. It gives error as Unexpected EOF encountered in bcp datafile. What can be the posibilities ?
March 20, 2012 at 9:04 am
Typical UNIX files have a single line-feed for each line (row) where Windows uses a CR-LF combination which should be compatible, but make sure the -r parameter is correct for the command and your format file is correct for your file.
The probability of survival is inversely proportional to the angle of arrival.
March 21, 2012 at 5:41 am
Is there any change in the return value or behaviour of bcp in case of any error in SQL 2008 ? like Data conversion resulted in overflow or Unexpected EOF encountered in bcp datafile
March 21, 2012 at 7:00 am
Not that I'm aware of. I usually use BULK INSERT VS BCP though.
The probability of survival is inversely proportional to the angle of arrival.
March 22, 2012 at 9:27 am
could you post your actual bcp command and 2-3 lines of the source data file ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 2, 2012 at 4:23 am
Sorry for the delayed response. There seems to be issue in the input file.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply