skipping tasks dynamically

• jones bastin

  Old Hand

  Points: 348

  More actions

  July 26, 2005 at 5:34 am

  #62000

  hi

       i need to skip some tasks depends on the conditon.

  Consider task 1 , task 2  , task 3 , task 4 , task 5 task 6 .... task 20 All tasks are executed serially.

  Step 1  i run the package.

  Step 2  consider Task 5 . task 11 are failed due to some data problem.

  Step 3  User corrects the problem in source ,

  Step 4 i will run package ; During this run , only failed task 5 and task 11 shoud be executed ;not all the tasks.

  currently i make all tasks inactive except task 5 and task 11.  i mention all tasks between task 1 and task 4 to make inacitve.is there any other solution  ?

  pls help me out

  Thanks in Advance

  Jones

• Vítor Nuno Viana Ferreira

  SSC Veteran

  Points: 255

  More actions

  July 26, 2005 at 10:53 am

  #577246

  Hi

  Why don't you try to use a Control Table where you register when a task runs OK. In the end of each task you register if it ends sussecfuly.

  In the end if all tasks run OK you will mark this DTS as OK, if not in the next run DTS will just run the tasks that didn't end.

  You should have some ActiveX to make the task ready to run or not.

  Hope it helps,

  Vitor

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  July 26, 2005 at 12:09 pm

  #577269

  Jones,

  Here is a link that will show you how to skip individual steps/tasks in a DTS package.

  http://www.sqldts.com/default.aspx?214

  Good Luck,

  Darrell