Event Handler Parent Task GUID

• Chavdar D.

  SSC Enthusiast

  Points: 179

  More actions

  August 29, 2011 at 9:48 pm

  #146080

  Has any guru managed to programmatically (no hard-coded values) make a task in event handler aware of the GUID of the parent task to which the event handler is directly attached? The idea is to execute [parts of] the event handler only for the task it is directly attached to and not for the children of that task by comparing to @SourceID system value.

  Any approach to solve the problem is welcome - custom tasks, custom assemblies, native SSIS techniques, etc.

• Bill Anton

  SSCrazy

  Points: 2437

  More actions

  September 3, 2011 at 2:05 pm

  #1376796

  not in 2005. in 2008 r2, there are new system variables that can help with this.

  Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com