Can someone help with a code that will automatically re-execute a failed
package.., try to re-execute it three (3)times, then exit if failed after
the third time. can someone help with a code?

Thanks


--
Message posted via http://www.sqlmonster.com

The simplest way to accomplish this would be to "encase" your package in an
ActiveX script loop which examined the individual step statuses as well as
that of the package after the final step. However, I think that you may
have other problems if you are anticpating this scenario. Maybe you should
look at why the package is failing, rather than trying to get DTS to bash
its head 3 times against bad input.
John Glass

"richard s via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote