Re: DTS and VFPOLEDB.1 Provider (Visual FoxPro) and Deleted records

[Darren Green]

I think the only solution is to pack the database first. SQL doesn't seem to
understand what these are and how to treat them.

--
Darren Green
http://www.sqldts.com

"Jesse Beveridge" <JesseBe...@discussions.microsoft.com> wrote in
message news:FBE99D2E-5300-467F...@microsoft.com...
> I seem to be having an issue with the VFPOLEDB.1 driver (Visual FoxPro OLE
> DB). When I create a linked server and select * from a table (free
tables) I
> get all the rows which are not marked as deleted, which is what I would
> expect. However, when I use the same driver in DTS I get all the rows
> including the rows marked as deleted. What is the difference in the way
DTS
> is using this driver? How do I exclude records marked as deleted from
> getting loaded?
> TIA,
> Jesse