DTS from SQL Server to Access

[TheJFM]

I am running a DTS from a SQL Server data source to an Access dB table.

How can I ensure that the Access table is truncated before the data is exported to Access?


Thanks

** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[NoCoolHandle]

Assumnig you are not using the wizard....

Create a task to do a delete on the access table and then use workflow to ensure that you don't run the copy step until success of the delete step..

Workflow is selectable from the menu in the package


HTH

Rob

 

[TheJFM]

Thanks

That's the direction I needed

** Don't reach for the moon when you have the stars. ;-) TheJFM **