SSIS: Conditional Split

Basically,

What i'm trying to Do.

if this condition is true or the value of the column (product) is null

then send email task.... Otherwise, move to the next task.

here is the query:

SELECT COUNT(product), product
FROM dbo.imp_ProductExclusionFlag
GROUP BY product
HAVING COUNT(PRODUCT) > 1

Since the approach I usually take is to bring everything into a staging table and then process it into the Production tables, I would simply use a set of 2 or 3 queries to accomplish this.  One (or, possibly 2) would pump the duplicates and NULL containing rows to the exceptions table.  I would then use another one to add the data to the Production table.  (Although, I would probably go ahead and code that last one as either a MERGE query or a set of 3, i.e. an UPDATE, an INSERT, and a DELETE)

yes, well i was not able to use a conditional split, i just used the on success and created to additional tasks, and use the logic, if the row count was greater than 0, or if any row was null, to use one path, and if it wasn't true to move to another task.... i still would like to get more information on using conditional splits. thanks for your comments.

i understand how the conditional split works, for each row, it works great, if you are checking a value row by row. However, the resutls of a query is what i'm trying to find out for my second condition.

i guess i could throw the results of a query into a variable, and use a count, if the count is greater than a certain number, i could use that to send the results another way......

Untitled.png