Hi,

When i run the following command i get the following error ,

c:\bcp TSQL.dbo.abc in c:\val.dat -fc:\val.fmt -SServer -Usa -Psa
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
format file
--------------------
Table Name :abc
--------------------
a char(10)
b char(10)
c char(10)
--------------------
Format File val.fmt
--------------------
8.0
3
1 SQLCHAR 0 10 "\t" 1 a
2 SQLCHAR 0 10 "\t" 2 b
3 SQLCHAR 0 10 "\r\n" 3 c
--------------------
Data File val.dat
--------------------
abc ABC test

I run this from the client side.. Can i know what is problem..

Regards
Govardhan MV

"Govardhan MV" <GovardhanMV (AT) discussions (DOT) microsoft.com> wrote

sorry, should be a formatting issue with my newsreader, but... I do not
see a 30-bytes-lenght record.
You defined a fixed column input file and IMO it should be something like
"abc ABC test "

I had some problems with record terminator too; check all records end with
CR+LF (x'0A'+x'0D') (or the contrary I dont remember)

Hi Paolo Fiore,

I tried out what you have specified but still i getting the same error.

Regards
Govardhan MV


"Paolo Fiore" wrote: