Hello,
I made a connection Manager in SSIS witch use "Microsoft OLE DB Provider for
Visual FoxPro". But when I retrive the date I see also the deleted rows.

What I must do in order to not see the deleted rows?
(The dBase ODBC driver has the property "Show deleted rows" unchecked)

Thank you,
Cosmin

Hello Cosmin,


Do you need to PACK the table as well?



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Cosmin,

I'm not sure what the dBase ODBC driver has to do with the FoxPro and Visual
FoxPro OLE DB data provider (the latest is downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates ).

The "Show Deleted Rows" may be a misnomer. There is also a checkbox in the
Visual FoxPro ODBC driver setup that references "deleted" but in this case
checking the box corresponds to the FoxPro "SET DELETED ON" command which
filters out deleted records.

The default for the VFP OLE DB data provider is SET DELETED ON, that is, it
does not retrieve deleted rows.

Allan mentioned packing the tables. While this is one way of eliminating
deleted rows it requires exclusive use of the tables and is usually done as
part of a weekly housekeeping routine, if done at all.



--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy (AT) cindywinegarden (DOT) com


"Cosmin" <Cosmin (AT) discussions (DOT) microsoft.com> wrote

Hi,

I didn’t have the "deleted" box checked in ODBC FP driver.
I also tried with "SET DELETED ON" and it's OK.
With the "PACK" solution provided by Allen I couldn't go because I don’t
have excusive access.

Thanks a lot for your answers,
Cosmin


"Cindy Winegarden" wrote: