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.
LVL 3
InNoCenT_Ch1ldAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jrb1senior developerCommented:
Check the definition in the .fmt files for the table in question.

However, a backup and restore might be eaiser.
nmcdermaidCommented:
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_Ch1ldAuthor Commented:
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
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

sanjeev559Commented:
Make sure the type r the same. Go to the transform radio button and u can see what r the different types.


Regards
Sanjeev
jrb1senior developerCommented:
If you didn't specify a directory or file name specifically, it's probably called:

bcp.fmt

I'd search for that on the machine you run bcp from.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShogunWadeCommented:
check the column definitions between the source and destination databases are identical.

run sp_columns MyTable   on each of the databases.    Without using format files BCP will require the columns to exactly match.
nmcdermaidCommented:
Are both databases MS SQL Server? because then its easier to use DTS or linked servers (though apparently just a little slower)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.