"Paul" wrote:

> I am new to DTS package design but want to do the following.
> I want the dts package to move several tables from an mssql 2000 dbase to an
> access file but it must first delete the tables in the access file. Also I
> want it to stop execution if any of the copies fail. I created a dts package
> that does the table copy by using all tasks, export data, save as dts package
> but it does not delete the table first in the access file so the file must be
> empty for it to work. Thanks.
> --
> Paul G