I am using a DBF as a staging table in a DTS package. At
the end (or anywhere in the package after the records have
been imported into SQL) I need to delete all records from
the DBF to ready the table for the next use. I cannot
figure out how to do this.
Any help would be appreciated.

If you refer to dBaseX tables:

1. Create a dBase5 connection (if you don't have one already), define the
dBase version and file path.

2. Create a SQL Task, linked to that connection, with the command
'DELETE FROM [DBF_TableName]'



"Steve" <anonymous (AT) discussions (DOT) microsoft.com> escreveu na mensagem
news:4d0d01c42c6a$182dd970$a601280a (AT) phx (DOT) gbl...