dbTalk Databases Forums  

Re:BCP error 22001 - String data, right truncation

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Re:BCP error 22001 - String data, right truncation in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger Quispe Del Castillo
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.