I am using SqlBulkCopy to insert millions of data from table1 to table2. I am having two questions:I am using sql serevr 2008 and c#
1. while inserting to table2, how to avoid duplicate insertion of records?
2. If there is any issue on 100 record, the how to continue insertion for the remaining records? Record that is failed will save in the log file with the error message