Does anyone know how to create an eventhandler for a dataflow task specific events (OnPipelinePostEndOfRowset, OnPipelineRowsSent, etc.)? These events are available for logging via the standard logging infrastructure, but there seems to no eventhandler for them.
The reason I'm interested is that parsing information logged by these events using builtin log providers is not easy (eg., the number of rows sent gets burried somewhere in the message column (i'm using sql provider). I'd like to capture this information and record it cleanly in a custom ssis metadata database i'm building. Any ideas are welcome. Thanks.
-alex
chianuri wrote:
Does anyone know how to create an eventhandler for a dataflow task specific events (OnPipelinePostEndOfRowset, OnPipelineRowsSent, etc.)? These events are available for logging via the standard logging infrastructure, but there seems to no eventhandler for them.
The reason I'm interested is that parsing information logged by these events using builtin log providers is not easy (eg., the number of rows sent gets burried somewhere in the message column (i'm using sql provider). I'd like to capture this information and record it cleanly in a custom ssis metadata database i'm building. Any ideas are welcome. Thanks.
-alex
Alex,
I've just checked this out and it was news to me that there are no eventhandlers for these events. Interesting. And annoying.
I guess your only option is to parse out the number of rows from the OnInformaiton event that you already know about.
Perhaps you could raise a request at Connect to get these eventhandlers added. I would vote for it.
-Jamie
|||Perhaps you could raise a request at Connect to get these eventhandlers added. I would vote for it.
The link can be found here, Jamie. Thanks.
|||[microsoft follow-up]
hello guys. Why is there no eventhandler for OnPipelineRowsSent?
Thanks
Jamie
No comments:
Post a Comment