XRM Data Transfer Error

Error 1
System.InvalidOperationException: Sequence contains no matching

Solution
PickList or OptionSet value is missing or Number  not matched

Error 2
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.

Solution
Add DNS.dbml -> DNS.designer.cs -> DNSDataContext method
partial void OnCreated()
{
    //Set the timeout value to 300 = 50 Min.
    base.CommandTimeout = 3000;
}
Error 3
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: A validation error occurred.  The value of 'leadsourcecode' on record of type 'contact' is outside the valid range. (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault).

Solution
sourcecode is our of range, for example if option value prefix (From Publisher entity) is started from 8000 and sourcecode valud contains 7000, crm will throw error.

Error 4
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: DateTime is less than minumum value supported by CrmDateTime. Actual value: 08/30/1878 00:00:00, Minimum value supported: 01/01/1900 00:00:00

Solution
 DateTime minDT = new DateTime(1900, 01, 01);
  if (ft.ProcessDate > minDT)
    food.dns_ProcessDate = vt.ProcessDate;