DSXchange

Hello,
We need to create a parallel job that when a query retrieves rows, the job aborts.

Something like a source (with an inside query) then if the query retrieves some records, the job aborts.

thank you -

Follow your query with a Transformer stage. Open up its output link constraint properties and set the "Abort After Rows" value.

Another possibility, again from a transformer, would be to leverage the DSLogFatal function based on your triggering condition. Bonus is you can also log the reason why you are aborting it.

Or is that not possible from a Parallel transformer?

@Craig It's not possible from a parallel Transformer, but it is possible from a BASIC Transformer stage.

But of course! Stick with the original suggestion.