I have 3 tasks in my DTS package - Task 1,2,3 in that order. Task 2
and 3 are execute package tasks. I want to be able to execute task 2
followed by task 3 only for the first time the package is run. For
subsequent runs, task 1 should be followed by task 3. I also want to
be able to schedule the execution of task 1 followed by task 3 every
hour.

Any help in this regard will be appreciated.

- Gayatri

Check out the following link to change the flow control of
a DTS package

http://www.sqldts.com/default.aspx?214,1

The other issues can be solved by using global variables
and ActiveX script tasks.