I have a range of Inner Packages (performing different data load jobs).
The outer package needs to call one of the Inner Packages depending upon a value in a table (or global variable, whatever).

I can do this by having Execute-SQL tasks (one per inner task) that compare the value in the table with the expected value and call RAISERROR if it doesn't match. Then only call the inner package 'On Success'. However, I don't want the Outer package to 'fail'.

How can I get the package to 'ignore' the fact that an Execute-SQL task has failed and still report a 'Success' message at the end?


- Andy Abel