title: SQLBULKCOPY.WriteToServer() does not throw an error, but it doesn't write back to the DB
body: <p><code>SQLBULKCOPY.WriteToServer()</code> does not throw an error, but it doesn't write back to the DB</p>
  
  <p><strong>My current attempt</strong></p>
  
  <pre><code>System.Data.DataTable tableMain = ConvertListToDataTableMain(transactionCrossCheck);
  using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString()))
  {
  
     //count = tableMain.Rows.Count;
     SqlBulkCopy bulk = new SqlBulkCopy(con);
     con.Open();
     bulk.BatchSize = 10000;
  
     bulk.ColumnMappings.Add(0, 0);
     bulk.ColumnMappings.Add(1, 1);
     bulk.ColumnMappings.Add(2, 2);
     bulk.ColumnMappings.Add(3, 3);
     bulk.ColumnMappings.Add(4, 4);
     bulk.ColumnMappings.Add(5, 5);
     bulk.ColumnMappings.Add(6, 6);
     bulk.ColumnMappings.Add(7, 7);
     bulk.ColumnMappings.Add(8, 8);
     bulk.ColumnMappings.Add(9, 9);
     bulk.ColumnMappings.Add(10, 10);
  
     bulk.DestinationTableName = "TransactionCrossCheck";
     bulk.WriteToServer(tableMain);
     // bulk.WriteToServerAsync(tableMain);
     bulk.Close();
     con.Close();
  
  }
  </code></pre>