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

#1

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" <JesseBeveridge (AT) discussions (DOT) microsoft.com> wrote in
message news:FBE99D2E-5300-467F-8C7E-AB5E762BC622 (AT) microsoft (DOT) com...

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS and VFPOLEDB.1 Provider (Visual FoxPro) and Deleted records - 08-06-2004 , 02:12 AM