sql server dts: 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.

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@discussions.microsoft.com> escreveu na mensagem
news:4d0d01c42c6a$182dd970$a601280a@phx.gbl...
[quoted text, click to view]