Friday, February 24, 2012

DTS.Pipeline Information - Can I Access this?

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