When automating an EBI 'Launcher' business process, where a database SQL select is to occur, use the HAS DATA task.
Using the HAS DATA task will allow us to test for data in a Storage ID. BY testing the Storage ID variable, we can ensure data is present before we launch the next task, ie. transformation task.
This will avoid a 'hard' error in EBI and allow the business process script to gracefully end.
By: Sean Hoppe on