Posted by mudassir.latif on 10/01/42 11:42

Hi,

I'm trying to upload a large number of log entries currently stored as
text files into a database table using bcp. For a few rows I get a
"right truncation" error and the offending rows are not uploaded to the
table.

I don't want to increase the size of the table varchar fields because
it's only about a dozen out of almost million rows that have this
problem ... I want to provide an override - i.e. if a row will result
in truncated data, truncate but still bulk copy the offending row. Is
that possible?

I couldn't find such an option in the documentation.

Any help is greatly appreciated.

Thanks,

Mudassir Latif

• Next in forum: Re: Querying a column with brackets in its name
• Prev in forum: 2000 vs 2005 -- AnsiNullsStatus
• Thread view: bcp right truncation: how to ignore

[Reply to this message]