Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to expose TaskHost properties using a Script Task Expand / Collapse
Author
Message
Posted Thursday, October 25, 2012 8:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 7:05 AM
Points: 6, Visits: 91
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

Post #1377013
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse