asked on

URGENT: error transfering data. ->Received invalid column length from bcp client

when me and my colleague trying to transfer data from one server to another, we received this error msg:
so can anyone tell me what does this msg means and what might cause this to happen?
tks in advanced! ;-)

Error at Destination for Row number 53680. Errors encountered so far in this task: 1.
Received invalid column length from bcp client.

jrb1

Check the definition in the .fmt files for the table in question.

However, a backup and restore might be eaiser.

nmcdermaid

So go to line 53680 and inspect the data. You will probably find that one of the columns has garbage in it and/or is too wide.

InNoCenT_Ch1ld

ASKER

the data at 53680 is valid.

but what is a .fmt files? and where to look for them?

btw, is there a way to transfer only a few table from a backup database(at server) to another database(another server)?

both database are similar, but database#2 only keep some particular table..
eg:
db1 db2
---------------------------------------
t1 t2
t2 t5
t3
t4
t5

SOLUTION

sanjeev559

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

jrb1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial