Transformation Fail on Zero (0) Writes was created by bruce.gibbins
I may have missed this option if it already exists. But I was wondering if there was an option to have a Flag on the Transformation Action in a package that would throw an 'Error' if there were records processed but nothing written?
In my case we get an inbound source file that is then filtered via a Validator with unmatched rows being DISCARDED in a Transformation. On occasion this results in no valid records being found and thus nothing written. The Transformation completes with no Error and nothing actually went wrong at our end except that they sent us a file that was missing the data we needed. We should still investigate.
The workaround at the moment for us is to interrogate the <Transformation Processed> and <Transformation Error> After Execution variables but just thought it would cleaner and in our case a bit more intuitive to have a simple flag that can then force the Transformation o end in error. Then the rest of the package flow would not have to jump into scripts to check for values and change workflow control from that point.