Is there any way I can capture the below information? I want to capture this to get the no of rows processed by each transformation.
[DTS.Pipeline] Information: "component "abc" (3798)" wrote 2142 rows.
[DTS.Pipeline] Information: "component "xyz" (4223)" wrote 1026 rows.
[DTS.Pipeline] Information: "component "abc2" (4324)" wrote 7875 rows.
Thanks
Jamie, as usual has you covered:http://blogs.conchango.com/jamiethomson/archive/2007/07/03/SSIS-Nugget_3A00_-Output-the-number-of-processed-rows.aspx|||
Phil Brammer wrote:
Jamie, as usual has you covered:
http://blogs.conchango.com/jamiethomson/archive/2007/07/03/SSIS-Nugget_3A00_-Output-the-number-of-processed-rows.aspx
Thanks Phil.|||This works if the transformation is in Script task, or rather if we want to generate our rows processed message in script or custom task. I dont think this can be used to access the information messages for a task.
Thanks
|||
This is what I meant to paste:
http://blogs.conchango.com/jamiethomson/archive/2007/03/08/SSIS_3A00_-OnPipelineRowsSent.aspx
Why not just use a row count transformation though?
|||
Phil Brammer wrote:
Why not just use a row count transformation though?
I already have a row count transformation, I'm just trying to see if I can knock-off the additional transformation.
Thanks
|||
Karunakaran wrote:
Phil Brammer wrote:
Why not just use a row count transformation though?
I already have a row count transformation, I'm just trying to see if I can knock-off the additional transformation.
Thanks
I don't understand. That's what it's for though. It's not really additional.
No comments:
Post a Comment