SqlBulkCopy Tutorial - Knowledge Base (KB)

Sql bulkcopy error - The given ColumnMapping does not match up with any column in the source or destination

I am trying to sqlbulkcopy to my sql table. My source that is the datatable has three columns and destination table has four columns the first column being idendity column. The destination table generates the values when record is inserted to the database...

SQLBulkcopy - Header of datatable getting inserted in the database table

The header of the datatable is getting inserted as a record in the table. I am incrementing the row number but still the header gets inserted. Could someone tell me what the issue is ? If you see the code below the I am doing rows.MoveNext.... XSSF...