How to best terminate a map
The functionality is perfect except that our infrastructure guys don’t like to see the SQL errors in the server’s error logs. I have tried using SQL Validation in a task, but that only stops the initial map, and lets the child maps continue to run.
What is the best way to completely terminate the map (and all child maps) if criteria is not met?
I had a ‘duh-me’ moment. NULL=NULL. In order for the SQL Validation to terminate, some value has to exist to evaluate as FALSE. Basically, I amended my query to compare to my dataset to ISNULL(APPROVAL_DOC, ‘NO APPROVAL’) as Approval
Retract that comment – it still allows the child maps to run. 🙁
If you would like to submit an answer or comment, please sign in to the eOne portal.