If I remember right it's because it's a VFP date field instead of a datetime field. Obvisouly if it's possible changing the VFP table sturcture would work...or in the DTS package DTOD() on that field....

>Hi,
>
>We're starting to look at upsizing our VFP data to SQL Server 2000. Problem is, when using DTS to import VFP databases, it chokes on the date fields. I'm sure there's a simple setting within DTS to accomodate VFP dates. Would anyone know the best way to handle this ? Thanks in advance.