string or binary data would be truncated,

Last Post 10 Aug 2004 10:51 AM by xcao. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
xcao
New Member
New Member

--
10 Aug 2004 10:34 AM
When I import into sql server tables, I often got error message:
string or binary data would be truncated, I know this is because the data I wanted to insert to the table has passed the limit of the data type length of the field.

Because I have so many field in the table, how can I find out quickly which record and which field it passed the limit? Or find out which field in the table has to increase length?

Thanks
xcao
New Member
New Member

--
10 Aug 2004 10:51 AM
That's good to know. That means package log will tell you the which field pass the limit.

How about insert from another query?
Thanks
satya
New Member
New Member

--
03 Sep 2004 05:31 AM
IF you're using BCP files to import the data, then check the columns in the tables are similar to the BCP file column contents. For instance if one of the bcp column is a TEXT field and table column is defined as VARCHAR then it will error.
You are not authorized to post a reply.

Acceptable Use Policy