stop ssis package when a For Each loop enumerator is empty

Problem : You want to stop a package when a For Each Loop Enumerator is empty.

Solution : Add a OnWarning event to the for each loop checking for right Error code.

Steps :

1. Add an OnWarning Event handler to the For Each Loop Enumerator:

2. Add A Script component to the Event handler that can read the following system variables:

3. Add the following code to test if the For each loop is empty: