<psandler70@hotmail.com> wrote in message
news:1158855941.230878.197360@h48g2000cwc.googlegroups.com...
> 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.
>

Arnie Rowland wrote:
> 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@hotmail.com> wrote in message
> news:1158855941.230878.197360@h48g2000cwc.googlegroups.com...
> > 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.
> >