Through DTS Package Records Not Deleted Permanently in Vis.FoxPro

[lendbz]

I have created a DTS Package to Transfer Data from a SQL Server Table to Visual Foxpro Table. And every time data goes from SQL to Vis.FoxPro Table, it should first delete all the records permanently in Vis.FoxPro Table and it should append SQL Data.

Everything is fine in designing and execution of DTS Package. But the problem I am facing is, In Vis.Foxpro Records are deleted but not permanently. Records are marked as Deletion only. After 2 to 3 execution of DTS Package, if we see the table it contains Deleted Records + New Records.

I know you can use the pack command in foxpro to delete the record permanently, but is there anyway to do it in DTS Package? (Pack doesn't work in DTS. when i use it, it gave me an error "Error Description:[Microsoft][ODBC Visual FOxPro Driver]No table is open in the current work area.")

Can anybody please guide me on this?

Tks in Advance,
lenny

 

[DrSql]

You might have to think about executing externally.
Bascally create your fox pro delete statement and call from DST package.

Dr.Sql
Good Luck.

 

[lendbz]

Can you give me more information on how i would create the foxpro delete/pack statement externally?

Thanks in advance,
lenny

 

[vongrunt]

Wasn't zap supposed to be faster than delete all+pack?

That error indicates current workarea is empty. Have you tried PACK IN <workarea|alias>? Is table opened (USE) at this point at all?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[lendbz]

oh nevermind. it worked now. THanks for the advice

 

[lendbz]

yeah. but somehow i can't get zap to work in DTS. so i delete first than "pack [tablename]" in my DTS package. using "zap [in tablename]" in DTS give me a "syntax error or access violation" error. If someone can help me get that to work it would be greatly appreciated, if not I will just use delete + pack for now.. thanks

lenny