Can't Import Blank Date

[dzdncnfsd]

I am trying to import a VFP 6.0 table into SQL 7.0. I created a DTS package to create the destination table then import the data. Everything is fine until SQL encounters a blank date in the VFP table, even though the CREATE TABLE script in SQL clearly states that it as a nullable field. How do I get around this? VFP will not allow me to convert the blank date fields to NULL in the VFP database.
Thanks,
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[Ruairi]

How about picking one date, say 01/01/1970 and replacing the blank date fields. Then you can either set up something in the dts package to insert a null date whenever this No Date value is encountered or continue using this date to mean No Date in your SQL server DB. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com