Re:BCP error 22001 - String data, right truncation -
11-26-2009
, 04:56 PM
the real problem is as shown in the message is truncated, it means that the
value you are trying to insert is greater than the length of the field in
the table and that happens because they are not finding the bcp separator
rows, in contrast to all the rows it is taking as a single row then the
solution would be to use something like this, I hope might help.
bcp Intratim.dbo.usuariosnofiscalizables in
\\cst02t12617\PerFiscalizable\RRHH1.LOG -c -r~ -Uusrbdintratim -Pintranet -t,
-SLIMBD1A\intranet
-r~ = separator
visit my website: www.espelfactorysolutions.com
url:http://www.ureader.com/msg/1162375.aspx |