SSIS - Restart a SSIS Package without using checkpoints

See more:

SQL

SSIS

Hi,

I'm hoping someone can help me with this.

I have a SSIS package that basically loops through a number of child packages based on whether they can restart or not. If they can restart then the master package can re-run the failed child package and carry on with a predetermined list in the event of any failure should a particular child package permit a restart.

Without going into the nitty gritty details of how this package works, I need to basically fail the whole master package (not an issue) in the event of any of the child packages failing, but then I need the master package to automatically start over again from the beginning because my own code will control which packages it needs to re-run and if it can restart them. The way the package works it needs to start from the beginning as it gathers a run number and logs to a custom event log I have implemented.

If I use checkpoints my understanding is this will try to restart from the last failed object which would be the For Each Loop container and not the first task which is to generate the run number the very first task in the control flow.

The master and child package combination run great as designed if I manually click the restart button in debug but I need some mechanism to automate this for me.

Basically all I need is an automated way of the restart button being clicked if the package fails.

Thank You

Andy