SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in
BCP data-file
0 rows copied.
I got this Error.
I even added the "format file".
I have 3 columns in the Table. No Identtity Column. and No PK's
CREATE TABLE dbo.Cust
(Sno INT,
Name Varchar(20),
Location Varchar(30)
)
And the .txt file has 3 columns... with Pipe delimited.
Ex:
1|Cust1|Newyook
2|John|Washington
100|Alan|Seattle