title: SQlBulkCopy The given value of type DateTime from the data source cannot be converted to type int of the specified target column
body: <p>I am receiving the above error code when attempting to do a SqlBulkInsert of the following "Cities" DataTable:</p>
  
  <pre><code>DataTable cityTable = new DataTable(City.TABLE_NAME);
  cityTable.Columns.Add("id", typeof(int));
  cityTable.Columns.Add("name", typeof(string));
  cityTable.Columns.Add("ascii_name", typeof(string));
  cityTable.Columns.Add("alternate_names", typeof(string));
  cityTable.Columns.Add("latitude", typeof(double));
  cityTable.Columns.Add("longitude", typeof(double));
  cityTable.Columns.Add("feature_class", typeof(char));
  cityTable.Columns.Add("feature_code", typeof(string));
  cityTable.Columns.Add("country_code", typeof(string));
  cityTable.Columns.Add("country_code2", typeof(string));
  cityTable.Columns.Add("population", typeof(long));
  cityTable.Columns.Add("elevation", typeof(int));
  cityTable.Columns.Add("modification_date", typeof(DateTime));
  cityTable.Columns.Add("admin1code", typeof(string));
  cityTable.Columns.Add("admin2code", typeof(string));
  cityTable.Columns.Add("admin3code", typeof(string));
  cityTable.Columns.Add("admin4code", typeof(string));
  cityTable.Columns.Add("gtopo30", typeof(int));
  cityTable.Columns.Add("timezone_name", typeof(string));
  cityTable.Columns.Add("version", typeof(Binary));
  </code></pre>
  
  <p>The following is the code that adds each entity to the DataTable:</p>
  
  <pre><code>object id = EvaluateNullity(parsedCity.Id);
  object name = EvaluateNullity(parsedCity.Name);
  object asciiName = EvaluateNullity(parsedCity.AsciiName);
  object alternateNames = EvaluateNullity(parsedCity.AlternateNames);
  object latitude = EvaluateNullity(parsedCity.Latitude);
  object longitude = EvaluateNullity(parsedCity.Longitude);
  object featureClass = EvaluateNullity(parsedCity.FeatureClass);
  object featureCode = EvaluateNullity(parsedCity.FeatureCode);
  object countryCode = EvaluateNullity(parsedCity.CountryCode);
  object countryCode2 = EvaluateNullity(parsedCity.CountryCode2);
  object population = EvaluateNullity(parsedCity.Population);
  object elevation = EvaluateNullity(parsedCity.Elevation);
  object modificationDate = EvaluateNullity(parsedCity.ModificationDate);
  object admin1Code = EvaluateNullity(parsedCity.Admin1Code);
  object admin2Code = EvaluateNullity(parsedCity.Admin2Code);
  object admin3Code = EvaluateNullity(parsedCity.Admin3Code);
  object admin4Code = EvaluateNullity(parsedCity.Admin4Code);
  object gtopo30 = EvaluateNullity(parsedCity.Gtopo30);
  object timeZoneName = EvaluateNullity(parsedCity.TimeZoneName);
  object version = EvaluateNullity(parsedCity.Version);
  
  cityRow["id"] = id;
  cityRow["name"] = name;
  cityRow["ascii_name"] = asciiName;
  cityRow["alternate_names"] = alternateNames;
  cityRow["latitude"] = latitude;
  cityRow["longitude"] = longitude;
  cityRow["feature_class"] = featureClass;
  cityRow["feature_code"] = featureCode;
  cityRow["country_code"] = countryCode;
  cityRow["country_code2"] = countryCode2;
  cityRow["population"] = population;
  cityRow["elevation"] = elevation;
  cityRow["modification_date"] = modificationDate;
  cityRow["admin1code"] = admin1Code;
  cityRow["admin2code"] = admin2Code;
  cityRow["admin3code"] = admin3Code;
  cityRow["admin4code"] = admin4Code;
  cityRow["gtopo30"] = gtopo30;
  cityRow["timezone_name"] = timeZoneName;
  cityRow["version"] = version;
  </code></pre>
  
  <p>And the code for EvaluateNullity:</p>
  
  <pre><code>    public object EvaluateNullity(object entity)
      {
          return entity ?? DBNull.Value;
      }
  </code></pre>
  
  <p>My understanding from this error message is that A DateTime value is being placed in one of the above int columns.
  However, a quick conditional debug later, and checks in the Immediate Window  reveal that none of the int columns ever have DateTime types being placed in them.
  <a href="http://desmond.imageshack.us/Himg42/scaled.php?server=42&amp;filename=mod1rm.jpg&amp;res=landing" rel="noreferrer">http://desmond.imageshack.us/Himg42/scaled.php?server=42&amp;filename=mod1rm.jpg&amp;res=landing</a>
  <a href="http://desmond.imageshack.us/Himg37/scaled.php?server=37&amp;filename=modyf.jpg&amp;res=landing" rel="noreferrer">http://desmond.imageshack.us/Himg37/scaled.php?server=37&amp;filename=modyf.jpg&amp;res=landing</a></p>
  
  <p>I am really stumped. </p>