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 ...