title: SqlBulkCopy ColumnMapping Error
body: <p>My goal is to copy generic tables from one database to another. I would like to have it copy the data  as is and it would be fine to either delete whatever is in the table or to add to it with new columns if there are new columns. The only thing I may want to change is to add something for versioning which can be done in a seperate part of the query. </p>
  
  <p>Opening the data no problem but when I try a bulk copy but it is failing. I have gone though several posts and the closest thing is this one:
  <a href="https://stackoverflow.com/questions/6651809/sqlbulkcopy-insert-with-identity-column">SqlBulkCopy Insert with Identity Column</a></p>
  
  <p>I removed the SqlBulkCopyOptions.KeepIdentity from my code but it still is throwing </p>
  
  <p>"The given ColumnMapping does not match up with any column in the source or destination" error</p>
  
  <p>I have tried playing with the SqlBulkCopyOptions but so far no luck.</p>
  
  <p>Ideas? </p>
  
  <pre><code>public void BatchBulkCopy(string connectionString, DataTable dataTable, string DestinationTbl, int batchSize)
  {
      // Get the DataTable 
      DataTable dtInsertRows = dataTable;
  
      using (SqlBulkCopy sbc = new SqlBulkCopy(connectionString))
      {
          sbc.DestinationTableName = DestinationTbl;
  
          // Number of records to be processed in one go
          sbc.BatchSize = batchSize;
  
          // Finally write to server
          sbc.WriteToServer(dtInsertRows);
      }
  }
  </code></pre>