Click here to Skip to main content
15,072,134 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900