June 18, 2008 at 1:38 pm
Hi All
In the dataflow task i have to intialize the variable COUNT=0
check for a condition like count<rownum and if true i have to insert the record into the table and if false ignore the record
and finally update the COUNT value with the rownum .So when the next record is comming in it will check the condition that rownum of prev record < rownum of the present record
can anbody assist me in this?
Thanx in Advance
June 19, 2008 at 12:27 am
You can update the variable with a rowcount transform.
Or if you want to get more funky with what you do (i.e. you want to count and then validate and the result of the validation also needs to be updated to the variable), try a scripting task.
Note that MS deems it to be bad practice to update a variable during a dataflow transformation script where the script type is a destination (based on that there may be more than one record passing through the stream)
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply