Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,087 of 19,505    |
|    tshad to All    |
|    SSIS not handling Rowcount correctly    |
|    21 Jan 11 13:00:01    |
      From: tfs@dslextreme.com              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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca