>Thanks for getting back to me so quickly.
>
>I followed your suggestion and replaced all of the empty date fields with .null. values but received exactly the same results - DTS is generating the same error, and I'm still 36 records short when I use the upsizing wizard.
Make sure you don't have any dates with the year earlier than about 1600. SQL Server has trouble with dates earlier than that, and Fox will let someone typo and put in a date like 0200 and not even complain if your not checking it.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc