Ensuring a Task Executes when a Package is finished Running

• SQL STEWIE

  SSCommitted

  Points: 1837

  More actions

  October 2, 2008 at 12:06 pm

  #199201

  I am trying to setup my package to fire an event when the package is finished running, regardless of if its successful or failed. I have tried creating a variable that is set to true when the following statement evaluates to true

  Dts.Variables("SourceName").Value.ToString() = Dts.Variables("PackageName").Value.ToString()

  in a script task on the OnPostExecute event (since it fires multiple times, I read this would only have it fire when the package was the source...).

  Once this variable is set to true, it is used in evaluating a completion path to fire off another task.

  This idea, however, does not seem to work properly. It either fires too many times, or not at all. Anyone have any ideas?

  Thanks,

  Michael

• ironic

  SSC Enthusiast

  Points: 129

  More actions

  October 2, 2008 at 2:58 pm

  #880209

  Why you don't put all the things that want to execute in a SequenceContainer and then add a completion constraint to the next task??