Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BCP problem

2 views
Skip to first unread message

tus...@gmail.com

unread,
Oct 12, 2006, 4:58:02 AM10/12/06
to
Hi All,

When i am running the bcp cpmmand to import the data from a
text file, this says the message below...

The command i have provided is

"C:\>bcp mira_dev.dbo.Audit_karthik_New in test.txt -f test.fmt -U
kchavan -P kchavan -S DLNSEMRA02 -e error.txt"

where the test.txt is the file which contains the actual data and
test.fmt contains the format for the same.

test.fmt and test.txt are bcped out from the database itself, and after
adding a couple of records, i want to bcp this again in which it says,

Text/image field is larger than the maximum value. Data truncated.
Unexpected EOF encountered in BCP data-file.
bcp copy in failed.

I am seeking the help on this, any help is highly appreciated.

Thanks in advance.

Regards,

Tushar

0 new messages