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