February 26, 2009 at 2:33 pm
Hi,
I am using the data flow task in which I have a Source and a row count task and then a destination.
I defined a variable , 'a' ( of package scope) and double clicked the row count task. Set the 'Variable Name' as the 'a'.
After my data flow task, I have a script task which displays the value of 'a'.
Everything is going fine and I see that there are rows inserted at the destination.
However, the script task displays the wrong row count.
Where am I going wrong ?
Thanks.
February 27, 2009 at 10:24 am
It sounds like you have the rowcount configured properly. Are there any other transforms or tasks that interact with this variable? Perhaps it's being modified elsewhere?
Do you see the correct rowcount in the pipeline connector within your data flow?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
February 27, 2009 at 7:56 pm
I made a silly mistake of declaring 'a' as a read variable rather than a read-write variable in the script task.
and thanks to you otherwise I would not have noticed the problem since I had decided to proceed in another way, until I saw your posting 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply