ID Number: Q76410
1.11 | 1.11 | 1.11
MS-DOS | WINDOWS | OS/2
buglist1.11
Summary:
Problem ID: PRSQL9109007
SYMPTOMS
When using the BCP utility with the /c or /n command-line
parameter, the message "Unexpected End of File" may appear
repeatedly across the screen and the data will not be loaded into
SQL Server.
CAUSE
One possible cause of this problem is that the command-line options
being entered are misinterpreted. The command-line parser will
ignore the /t option if it occurs before the /c or /n option. In
the case of the /c, BCP will assume a fixed-length data file.
WORKAROUND
The way to avoid this problem is to make sure that the /c or /n
option is always in front of the /t and /r options:
bcp pubs..test in data /Usa /P /Smyserver /n /t,
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. Microsoft is researching this problem and will post new
information here as it becomes available.