Hello:
I have created a SQL2K DTS package that drops 2 tables in
a reporting database and replaces them with new data. I
use a SQL task to drop the tables and then I import the
data from one sql server to the reporting DB.(also SQL)
After the data transformation runs, I then run several
sql tasks that alters the data into a format that we need.

My problem is that although the process works fine once,
I get errors on subsequent attempts to reload the data.
It appears that the package is also dropping the data
transformations and the step fails. Is there anyway to
avoid this?

Thanks for any assistance

Brennan