Alternative for Checkpoint in SSIS

• SK152

  SSC Enthusiast

  Points: 166

  More actions

  June 16, 2018 at 4:05 pm

  #413899

  Hello

  I had a package which has a parallel processing of control flow tasks because of that checkpoint is not working as expected.Please let me know an alternative to overcome from this.

  I tried a way to overcome this by using pre-execute event(For Every Task) to disable the executed tasks when we rerun the package again after failure.In pre-execute event I retrieve the flag value to the variable from log Table(Which was created every time package rauns.Table have package details,tasks details and Flag-To store whether the tasks executed or not in the form of True or Flase) and pass the variable to the task expression to disable it.But package is not executing as expected.Expression i used was Var_name =="True" ? (DT_BOOL) 1 DT_BOOL)

  Please let me an alternative for this. I need this on urgent basis.

  Note: I'm looking for - Is any alternative for checkpoints
  Thanks in advance

  SK

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 16, 2018 at 4:16 pm

  #1994212

  Duplicate post.  Please post any responses here: https://www.sqlservercentral.com/Forums/1969401/Alternative-for-Checkpoint-in-SSIS