I would like to use the DTS utility to import the data coming from a dbf codebase file (source) into MS SQL 2000 database (destination).
What my problem is that there are some records from the dbf has a delete flag turned on, when I do the import, everything was inserted into SQL database except for those marked delete ones. What can I do? Any suggestion of the ODBC driver?
If all records can be imported into SQL 2000 with a column specified whether this record are deleted or not, then it would be perfect. Thanks.
I can send you the dbf file for your investigation. Thanks.