SSIS - Data Flow - How do I split on a 0 row return?

Question

I am trying to make a conditional split in the data flow in SSIS.

My Source can return 0 rows (and is expected)

I want the split to split on if there is 0 rows returned, or any rows returned.

The problem I am seeing currently is that the Data Flow stops if there are 0 rows returned from the source, it doesn't even get to the split condition.

How can I make a split on a 0 row return??

Answer 1

In the Data Flow, when no rows are read from a source, the Data Flow stops. One approach would be to get your source return the row count and not the rows itself. Then you could make an conditional split on that number. In the part where the count is higher than 0 you can get your rows from your source.