BCP - Truncate error

I have a table with 22million rows. I bcp out using the
following
bcp dbname..table out table.out -c -T -Sserver
The file is created no problem.
When I try and run against another server (table schema
the same) I get the following error.
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data,
right truncation
Now I tried to define the column datatype, but when I
tried to enter one for Varchar, it wasn't a valid datatype
for BCP - Could this be why I'm receving the error?
Any help would be appreciated.
Thanks
SusanOr the "N" switch.
>--Original Message--
>I have a table with 22million rows. I bcp out using the
>following
>bcp dbname..table out table.out -c -T -Sserver
>The file is created no problem.
>When I try and run against another server (table schema
>the same) I get the following error.
>SQLState = 22001, NativeError = 0
>Error = [Microsoft][ODBC SQL Server Driver]String data,
>right truncation
>Now I tried to define the column datatype, but when I
>tried to enter one for Varchar, it wasn't a valid
datatype
>for BCP - Could this be why I'm receving the error?
>Any help would be appreciated.
>Thanks
>Susan
>
>.
>