I am currently working on migrating data from one Sage CRM system to another.  The current system was established in 2006 and for many reasons needs a "fresh start".

My biggest challenge has been the communications records.  There are about 350,000 records.  If I try to insert them all at once, I get the following message...

Therefore, I have used smaller chunks of data.  As I narrowed down the data, I thought I might find a record causing the error message and determine the cause.  However, that has not been the case.  As I narrow the data, I am able to get the records to go in.  Therefore, I am wondering if anyone has had a similar experience and might be able to help me understand why the message occurs or a better way to approach this as the more inserts I have to do, the longer this will take.

Example:  >#01/01/2008# And <#12/31/2008#  -- failed

>#01/01/2008# And <#06/30/2008# -- success

>#07/01/2008# And <#12/31/2008#  -- failed

>#07/01/2008# And <#9/30/2008# -- success

>#10/01/2008# And <#12/31/2008#  -- failed

>#10/01/2008# And <#10/31/2008#  -- failed                   <--this will not insert

>#10/01/2008# And <#10/15/2008#  -- success              <--but this will

>#10/16/2008# And <#10/31/2008#  -- success              <--and this will

>#10/31/2008# And <#12/31/2008#  -- failed

...still working on the combos to get this data in...

Any assistance would be greatly appreciated.  Thank you!!