Posted on: 11/2/2014 4:01:46 PM | Views : 457

I used code below to upload datatable (from CSV) using sqlbulkcopy but got an error said "can't conversion string to decimal  ..."
There are about 2 million row in which there are 290 columns to upload.
Does  sqlbulkcopy class have index to indicate where is error existing?

Dim bc As SqlBulkCopy = New SqlBulkCopy(dbConn, SqlBulkCopyOptions.TableLock, Nothing) bc.DestinationTableName = "test"
dbConn.Open()
bc.WriteToServer(dt) // error appended here 

Go to the complete details ...