>So if this is the case, how to go about to ensure a successful mirgration
>of DBF data to SQL Server?

You'll have to convert empty dates to something SQL Server will understand. You could handle it on the FoxPro side by replacing the empty dates with NULLs or maybe Jan 1, 1900 which is SQL Server's zero date.

Within DTS, you'd have to write some ActiveX script to test for the empty date and convert it to something else. I'm not sure what a VFP empty date looks like in ActiveX script. In VB it was a very small number, -2 million + change. If you find it out, please e-mail me at mlevy@isresearch.com. DTS and VFP is the topic of my next article for FoxTalk.