>BTW, I installed the latest VFP OleDB provider on that server. I thought the problem could have been related to it. I run the package again and ended up in the same situation. The package failed on a specific table on a datetime field. There is nothing wrong with the values for all records in regards to that field. I have either empty values or good ones. I also attempted to replace all empty values with a value. This doesn't change anything. The mapping is recognizing the VFP datetime field and maps it to SQL Server datetime field.
>
>I have a lot of datetime fields elsewhere and they all work ok.

What is the MIN() and MAX() value for the field (excluding empty values) ?