bcp doesnt throw an error when the data length exceeds size of the column

Hi,

We are using bcp in SQL 2008 R2 to import the data from flat file. When the data length exceeds the size of the column, it doesn't throw any error instead it has ignored the row.

Please suggest me how to truncate and load the data into table.

Thanks,

Pasha

March 29th, 2015 12:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics