I am in need of help for designing a very simple DTS package. I am just not
able to get the design working the way I want it to...

1. Connect to an Excel Table
2. Create new table in SQL (in the "vcms" database / "SR_Traps" is the new
table name).
3. Transform data from the Excel table into the SR_Traps table.

(steps 1 thru 3 are complete)

4. NOW... I need to be able to schedule this process. However, the DTS
needs to first drop the SR_Traps table FIRST, then re-run steps 1 thru 3 as
above.

I am using the DTS Package designer in SQLServer2000. I wish I could attach
an image of the current package, but I am unable to figure out how to perform
step #4 FIRST, then run 1-3 again -- of course, repeating this process daily.


Thanks for any input!

j

Nevermind. Figured it out.

j

"jamesfreddyc" wrote: