FoxPro Oledb provider,SSIS and Deleted Records

From: "Andrew Stewart" <andrew.stewart@xxxxxxxxxxxxx>
Date: Tue, 29 Apr 2008 18:49:47 +1200

Hi,
I have created an SSIS Package to import data from a DBF file, no problem.
Data has been import without issue.
A number of deleted records have also been imported as valid records.

I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I
believed by default didn't select deleted records.
Trying to reconcile between the VFP application, the dbf file, and the
imported data in SQL database, I noticed a number of deleted records. Is
there anyway to set the connection to not show deleted records? Or in the
query selecting from the source?

.

Prev by Date: RE: Use of CASE with Microsoft OLE DB Provider for Visual FoxPro
Next by Date: RE: Use of CASE with Microsoft OLE DB Provider for Visual FoxPro
Previous by thread: Use of CASE with Microsoft OLE DB Provider for Visual FoxPro
Next by thread: Cannot save data connection in VS 2005 for a custom OLE DB Provide
Index(es):
- Date
- Thread

Relevant Pages

Re: Fill & Lock
... you'd need to know how many deleted records ... dbf file. ... That way the recno() would still differ from ... record_number, due to switching records. ...
(microsoft.public.fox.helpwanted)
Re: Fill & Lock
... Reccountalways counts deleted records. ... dbf file. ... That way the recno() would still differ from ... record_number, due to switching records. ...
(microsoft.public.fox.helpwanted)
Re: SSIS,DBF and Deleted Records
... but if you are explict in your selection then deleted ... I have created an SSIS Package to import data from a DBF file, ... A number of deleted records have also been imported as valid records. ... imported data in SQL database, I noticed a number of deleted records. ...
(microsoft.public.sqlserver.dts)
SSIS,DBF and Deleted Records
... I have created an SSIS Package to import data from a DBF file, ... A number of deleted records have also been imported as valid records. ... imported data in SQL database, I noticed a number of deleted records. ...
(microsoft.public.sqlserver.dts)
Re: SSIS,DBF and Deleted Records
... but if you are explict in your selection then deleted ... I have created an SSIS Package to import data from a DBF file, ... A number of deleted records have also been imported as valid records. ... imported data in SQL database, I noticed a number of deleted records. ...
(microsoft.public.sqlserver.dts)