I have a job fetching many XML files in a directory and loading to target tables.
It's a scheduled job. I need to set up a mechanism, checking if files exist, then execute job or not.
That's first.
And if files exist, I need a variable to grab # of records ported from the XML files, and do a count.... if the count is Zero, the scheduler will send an alert by email.
I have the business logic, but does not know how to implement this in BODS.... any help is appreciated.