home bbs files messages ]

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