What FoxPro data tools can I use to search for corrupted data?

Question

I have SQL Server DTS packages that import data from a FoxPro database. Until recently, this worked fine. Now the script that imports data from one of the FoxPro tables returns about 470,000 records in the import. I just pull the data into a table with fields with zero varchar, so I think this should be a problem with weird / corrupt data.

What tools would you use to track such a problem?

FYI, this is the error I get:

Data for source column 1 ('field1') is not available. Your provider may require that all Blob columns be right in the original result set.

There should be no blob columns in this table.

---

Thanks for the suggestions. I do not know if this is really a corruption problem. I just started downloading FoxPro from my MSDN subscription, so I will see if I can open the table. SSRS opens the table, it just suffocates before starting all the records. I'm just trying to figure out which record he has problems with.

Answer 1

Cmrepair is a great freeware utility to repair damaged .DBF files.

Answer 2

Have you tried writing a small program that simply copies existing data to a new table?

Besides,

http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~VFP

Answer 3

Foxpro ... , , . foxpro, ?

Answer 4

470 000 , , , , , FoxPro 2 . , , 2- .

Answer 5

@Lance:

Visual FoxPro, :

SET TABLEVALIDATE 11
USE "YourTable" EXCLUSIVE    && If the table is damaged VFP must display an error here
PACK    && To reindex the table and deleted "marked" records
PACK MEMO    && If you have memo fields

, , :

SELECT * FROM YourTable WHERE EMPTY(YourField)   && All records with YourField empty
SELECT * FROM YourTable WHERE LEN(YourMemoField) > 200   && All records with a long memo field, there can be corrupted data

...

Answer 6

(www.shershahsoft.com) ( ).

Foxpro/FoxBase/Dbase. . 1 .

. , "" " ", . , "CorruptData" , , .

, , Windows CheckDsk , . , , , Windows CheckDsk. RepairDatabases .

, , ( ). . Repair Databases , . , - .

" ", . , , . ( .)