Import Data problem

I need to import data from VFP into SQL ,
Now, I found many many fields's length is different.
I need to compare one field by one field length, otherwise AS I process
Insert A ... select ... from B.
There is always error about the Truncated error .
however, I don't know which field is wrong, Any tools or any method can let
me know which field is wrong ?
thanks
Unfortunately, you cannot find out the exact column that is producing the
error message, as the message doesn't include the column name. I'm afraid
you'll have to do a manual compare:
http://vyaskn.tripod.com/programming_faq.htm#q1
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:OdBQXbDNFHA.2136@.TK2MSFTNGP14.phx.gbl...
I need to import data from VFP into SQL ,
Now, I found many many fields's length is different.
I need to compare one field by one field length, otherwise AS I process
Insert A ... select ... from B.
There is always error about the Truncated error .
however, I don't know which field is wrong, Any tools or any method can let
me know which field is wrong ?
thanks