CliffB,
You are right, the task that calls the SP should be assigned to the on post execute event, I made this change after the article was approved so I it did not take.
Sorry for joining the party a little late I am actually on vac with limited Internet access. But let me know if you have any questions.
Thanks
Frank Banin
BI and Advanced Analytics Professional.