I figured it out. There were a couple tables with bad dates. We are good to go now. Thanks for all the help.
>Most likely the empty dates are responsible. Replace them with NULLs.
>
>
>>I did get a 6 month contract to hire today. And it's at a competitor to my former scam company. My first task is to export data from the old VFP accting app to SQL Server.
>>
>>We are trying to do an Import thru SQL Server. But we are getting an error on date columns. I'm sure this has been discussed here before is there a way to fix this, or another way to transfer the data. The error is:
>>
>>Insert error......(column, dtype_dbtimestamp), status 6: data overflow. Invalid character value for cast specification
>>
>>
>>Thanks.
(On an infant's shirt): Already smarter than Bush