Drop table in Access through SQL Server DTS package

[ynnepztem]

I have created a DTS package using SQL Server 2000 that will copy a table into an Access database. After the first time the package ran, it failed because the "Create" step failed (of cours it did, the table in Access is already there). I want to Drop the Access table before I re-insert the same data. Any help would be appreciated.

 

[Dilyias]

Yes, in the step where you pick your tables, click the [...] in transformation and there is a check box for "drop and re-create table"