I have a OnPre Execute event on a task in SSIS. I want to be able to assign the parent task name to this event to a variable.
I am using a script task. Are there any examples available on how to achieve this?
I have looked at the DTSProperty, but have to admit that I am struggling with this.
Once I have assigned the taks name to the varaible, I can then use my bubble up error handler, and still be able to log the name of the task which caused the error.
Many thnaks
RudyThe name of the task (more accurately - the container) that threw the event is available in the System::SourceName variable in the eventhandler.
Is that what you want?
Here's an example of doing something very similar: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx
-Jamiesql
No comments:
Post a Comment