dbTalk Databases Forums  

SSIS not handling Rowcount correctly

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SSIS not handling Rowcount correctly in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tshad
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.