Greetings,

I am new to the SqlBulkCopy operation provided by ADO.NET 2.0. I am
reading a pipe delimited text file into a datatable. I can bind the
datatable to a datagrid just fine.

When I try to run the SqlBulkCopy with this datatable I get this error

System.InvalidOperationException: The given value of type String from
the data source cannot be converted to type decimal of the specified
target column.

Unfortunately there is nothing that will tell me (that I have found)
that specifies the column that it is failing on. I have two questions.
 Is there a way I can tell which column is the offender and how do I
get around this?

If code needs to be posted let me know.

Thanks.