SSIS not handling Rowcount correctly -
01-21-2011
, 03:00 PM
I have an SSIS package that uses the Row Count transformation task and puts
the row count into a variable called RowCnt.
I am passing the results to a Conditional Split that filters on 2 values
going to 2 different Derived Column tasks. And has a 3rd that does:
@[User::RowCnt] == 0.
When I debug, I get 300 rows going to the first filter task, 250 going to
the 2nd task and 320 going to the "No Rows" task????
What I want is to have the Conditional Split go to the "No Rows" task when
no rows are returned.
Am I missing something?
Thanks,
Tom |