August 24, 2011 at 11:54 pm
Hello Friends,
I am testing how the rowcount transformation works and i created a simple package to test it. i created a Dataflow task. It has source adapter whose o/p is connected to the rowcount transformation. I have selected the variable to which the row count value would be stored. I am deriving a new column with the value from the variable and i am adding a Union All transformation to the pipeline just to check the o/p. i added a dataviewer to the path of the union all and when i check the derived column which holds the row count, the value is getting displayed as 0. What could be wrong in this. I think i am missing something silly here.
I am attaching the Dataflow screenshot.
Please help me.
Regards,
Murali
August 25, 2011 at 12:14 am
Hi..I'm not convinced why you are using a UNION ALL in this context..??
August 25, 2011 at 12:17 am
I created this package just to test the functionality of the Row Count Transformation and i dont want a destination adapter. So i am using Union All as a temporary destination to check the output rows using data viewers. I believe using Union All would not affect anything regarding Rowcount Transformation.
Correct me if i am wrong.
August 25, 2011 at 12:52 am
Hello friends,
The issue was due to the fact that i was using the variable updated by the Rowcount Tran in the same DFT. We cannot use the variable until the DFT is over.
Regards,
Murali
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply