Hi.
When I use a standard Command,i can set ANSI_WARNINGS off
SqlCommand cmdExcel = new SqlCommand("SET ANSI_WARNINGS OFF", conn);
cmdExcel.ExecuteNonQuery();
and then if I am Updating any fields where data is too long for th field, the data is truncated.

I am using the SqlBulkCopy and am running up against similar issue but dont know how to use SET ANSI_WARNINGS OFF
Anybody know iof this can be done

TIA
Gerard