Hello I have Union All in my Data flow task, the inputs are Look up output and conditional split. When i view the data in after conditional split i get row count of 1030 in buffer but the Union All output buffer shows in 997 rows? what happened to 33 rows? no rows for look up output I cannot redirect the Union All row to see if there is anything causing to these 33 rows to disappear. Any suggestions would be appreciated Regards

Can you take a picture of the screen in BIDS, host that picture somewhere on the web, and post a link here? (See the "posting hints" sticky thread above for details.) Talk to me now on

Ok, i found the problem. It was not the Union All task but conditional task that was the problem. I have one condition like below Case 1 (Gender == "FEMALE") && ((Code == "80010") || (Code == "80300") || (Code == "9100") || (Code == "90500")) and the row that do not meet above condition should goes to conditional split default output but the row are not For example: 15304 row are input to conditional split 26 satisfies Case 1 and conditional default output is 10977 about 4301 rows are missing? Why are they not directing to default output?

Has the data flow completed executing when you read those numbers off the screen? Talk to me now on