All,

This is for SQL 2000 DTS.

It is possible to run a task (ActiveX in this case) at the completion
of a package, regardless of sucess/failure of any of the steps?

I have a package that has a number of steps, each of which run only
when the preceding step was sucessful. I would like to run an ActiveX
script at the end of these steps, regardless of whether all the steps
were completed successfully or not. If I add a step at the end, it
will only get hit if all the steps are successful.

I believe I can do this if I wrap the package in another package, but
I'd like to avoid this if possible. I know I can also have all the
steps branch via On Failure to the final task as well. I was hoping
there was a more elegant way of doing this.


Thanks for any help.

I think you have it figured out.

Branching to the last step is the 'best' method. In actuality, it is no
different that having any failed step start another package or job.

On failure, you have to do something or quit. Sounds like you want to do
something.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


<psandler70 (AT) hotmail (DOT) com> wrote

Catching and responding to failures within DTS is not handled to
naturally - I might suggest you wrap it using a STEP 2 from a SQL_JOB
that executes the package; in that case you can signal that on JOB STEP
1 failure (or success) merely goto next STEP. STEP 2 would of course
could be an ActiveX script.

Arnie Rowland wrote: