title: SqlBulkCopy hangs without any exception or timeout when inserting a datatable with even a single row
body: <p>Having an issue, basically I have a very large datatable (50,000 rows) and I am using SqlBulkCopy to insert it via this function I wrote:</p>
  
  <pre><code>public static void DoSqlBulkCopy(string connectionString, string destinationTableName, DataTable dataTable, int batchSize = 2000)
  {
      using (var bulk = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.CheckConstraints))
      {
          bulk.BatchSize = batchSize;
          bulk.DestinationTableName = destinationTableName;
  
          for (int i = 0; i &lt; dataTable.Columns.Count; i++)
          {
              bulk.ColumnMappings.Add(dataTable.Columns[i].ColumnName, dataTable.Columns[i].ColumnName);
          }
  
          bulk.WriteToServer(dataTable);
      }
  }
  </code></pre>
  
  <p>This code has worked for other stuff but on this dataset it just hangs on WriteToServer.</p>
  
  <p>I scratched my chin for a bit and fired up the SQL profiler but there is no activity.</p>
  
  <p>Any suggestions? It doesn't timeout either, I left it overnight.</p>