How to expose TaskHost properties using a Script Task

• superstar6778324

  SSC Veteran

  Points: 252

  More actions

  October 25, 2012 at 8:22 am

  #74464

  Hi

  I have built a custom logging feature through the use of the Execute SQL Task SQLStatementSource property, using dynamic SQL that utilise System variables and event handlers.

  There are some things that are not available through the help of System variables such as task result, tast status etc and I would like to capture these details for the tasks in my packages.

  I have learned of the TaskHost class - http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.taskhost.aspx and wanted to know is it possible to get the following properties using a script task on an event handler -

  ExecutionDuration

  ExecutionResult

  ExecutionStatus

  StartTime

  StopTime

  I would like to capture these properites and put them into variables using the script task and then my dynamic SQL within the SQLStatementSource property can capture as variables and output when an event handler fires.

  This is what I would like to and want to know if it what I have described is possible?

  Any pointers to help me get started would be good as I am still getting familiar with scripting and the Ingteration Services Object Model.

  Thank you