Home All Groups Group Topic Archive Search About

Unexpected EOF problem with BCP in

Author
11 Jan 2006 2:20 PM
Chen
Hi,
Does anybody know that when execute bcp in utility, I received error
message: Unexpected EOF from SQL Server 2000 with SP4. Actually the data text
file is bcp out table_name.txt and export/import table data in same database
different table names at the same server.
Regards!
Chen

Author
11 Jan 2006 10:34 PM
Erland Sommarskog
Chen (C***@discussions.microsoft.com) writes:
> Does anybody know that when execute bcp in utility, I received error
> message: Unexpected EOF from SQL Server 2000 with SP4. Actually the data
> text file is bcp out table_name.txt and export/import table data in same
> database different table names at the same server.

You will need to provide more information. For instance post the
CREATE TABLE statements of the two tables together with some
INSERT statements of sample data for the first table that demonstrates
the problem. Of course, we need to see your BCP statements as well.



--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button