I have a very simple package of SQL Data Flow Task that executes a query and deletes the result.
Is there a way to make my package fails when there's no result in the query? I try adding Execute SQL Task to get the result Count, but I'm not sure how to make it fail when result Count = 0.