Since you are using
SqlBulkCopy
you can create auto increment column in destination table and all add column mappings to other columns. when you select data, you can give columns names and add mappings when you call
WriteToServer
. for example
SqlCommand cmd = new SqlCommand("select column1, columns2 from tbdata", con);
then the mappings
SqlBulkCopy bulkInsert = new SqlBulkCopy(con_str);
bulkInsert.DestinationTableName = "tbdata";
bulkInsert.ColumnMappings.Add("column1", "column1");
bulkInsert.ColumnMappings.Add("columns2 ", "columns2");