Electronic Checklist that can execute SSIS packages based on a flag/Correct Tick

• Ismail Cassiem

  SSC-Addicted

  Points: 484

  More actions

  September 12, 2007 at 1:35 am

  #153817

  Electronic Checklist that can execute SSIS packages based on a flag/Correct Tick

  1. Task1 : (with a tick, indicating successfull)

    Now that task is green tick execute Task2

  2. Task2 :

  Some other software or so that can relate with SSIS or DTS then return to a value or so then indicate on the software checklist that is done the continue to next task.

  The reason being is that we can open the electronic checklist & to also view the checklist & indicate everything was successfull if not indicate the red ticks(unsuccessfull).

  We execute a list of tasks (being DTS packages, SSIS, copying of ascii files to network) etc.  one after another

  The problem is that it's unstable were the task will execute based on a previous task that might have encounted errors so we only really notice once a user complains or on arrival in the mornings then it's to late.

  The idea that we want to incorporate a electronic checklist were it execute a job goes back to the checklist(?) sets it's flag or ? and then on true/flag execute the next task.

  I apologise as this is part of another post but I totally messed up the previous post with the wrong question.

  Regards