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?
(Sorry for the repost, I'd like MS to answer this one)
TIA,
Jesse