title: SqlBulkCopy Not Working
body: <p>I have a <code>DataSet</code> populated from Excel Sheet. I wanted to use SQLBulk Copy to Insert Records in <code>Lead_Hdr</code> table where <code>LeadId</code> is PK. </p>
  
  <p>I am having following error while executing the code below:</p>
  
  <blockquote>
    <p>The given ColumnMapping does not match up with any column in the
    source or destination</p>
  </blockquote>
  
  <pre><code>string ConStr=ConfigurationManager.ConnectionStrings["ConStr"].ToString();
  
  using (SqlBulkCopy s = new SqlBulkCopy(ConStr,SqlBulkCopyOptions.KeepIdentity))
  {
      if (MySql.State==ConnectionState.Closed)
      {
          MySql.Open();
      }
  
      s.DestinationTableName = "PCRM_Lead_Hdr";
      s.NotifyAfter = 10000;
  
      #region Comment
      s.ColumnMappings.Clear();
  
      #region ColumnMapping
      s.ColumnMappings.Add("ClientID", "ClientID");
      s.ColumnMappings.Add("LeadID", "LeadID");
      s.ColumnMappings.Add("Company_Name", "Company_Name");
      s.ColumnMappings.Add("Website", "Website");
      s.ColumnMappings.Add("EmployeeCount", "EmployeeCount");
      s.ColumnMappings.Add("Revenue", "Revenue");
      s.ColumnMappings.Add("Address", "Address");
      s.ColumnMappings.Add("City", "City");
  
      s.ColumnMappings.Add("State", "State");
      s.ColumnMappings.Add("ZipCode", "ZipCode");
      s.ColumnMappings.Add("CountryId", "CountryId");
  
      s.ColumnMappings.Add("Phone", "Phone");
      s.ColumnMappings.Add("Fax", "Fax");
      s.ColumnMappings.Add("TimeZone", "TimeZone");
      s.ColumnMappings.Add("SicNo", "SicNo");
      s.ColumnMappings.Add("SicDesc", "SicDesc");
  
      s.ColumnMappings.Add("SourceID", "SourceID");
      s.ColumnMappings.Add("ResearchAnalysis", "ResearchAnalysis");
      s.ColumnMappings.Add("BasketID", "BasketID");
      s.ColumnMappings.Add("PipeLineStatusId", "PipeLineStatusId");
  
      s.ColumnMappings.Add("SurveyId", "SurveyId");
      s.ColumnMappings.Add("NextCallDate", "NextCallDate");
      s.ColumnMappings.Add("CurrentRecStatus", "CurrentRecStatus");
      s.ColumnMappings.Add("AssignedUserId", "AssignedUserId");
      s.ColumnMappings.Add("AssignedDate", "AssignedDate");
      s.ColumnMappings.Add("ToValueAmt", "ToValueAmt");
      s.ColumnMappings.Add("Remove", "Remove");
      s.ColumnMappings.Add("Release", "Release");
  
      s.ColumnMappings.Add("Insert_Date", "Insert_Date");
      s.ColumnMappings.Add("Insert_By", "Insert_By");
      s.ColumnMappings.Add("Updated_Date", "Updated_Date");
      s.ColumnMappings.Add("Updated_By", "Updated_By");
  
      #endregion
      #endregion
  
      s.WriteToServer(sourceTable);
  
      s.Close();
  
      MySql.Close();
  }
  </code></pre>