title: Get duplicate records before bulkcopy to database
body: <p>I am now copying data from one client database <code>DB2</code> to main database <code>DB1</code> by using <code>SqlBulkCopy</code>.<br></p>
  
  <pre><code>DataTable dtTable = new DataTable();
  sqlDB2DataAdapter.Fill(dtTable); //select * from tblOrdersDB2
  
  SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlDB1Connection)
  bulkcopy.DestinationTableName = "dbo.tblOrdersDB1";
  bulkcopy.WriteToServer(dtTable);
  </code></pre>
  
  <p>By creating <a href="http://msdn.microsoft.com/en-us/library/ms188783.aspx" rel="nofollow">INDEX</a> ,when I will insert data with bulk to db, all duplicate values will not inserted.<br>
  The problem is I want to report a CSV file of all duplicate records being ignored.<br>
  How can I achieve this duplicate records?Is there a simple way to do that?<br>
  Thank you.</p>