The idea of DTS package inside another is interesting. However, the
key issue here is how to deliver/send an exception/error note/message
to sys admin when there's source data problem. Unfortunately the SMTP
call from sql server in my environment is disabled. I'm looking to see
if alternative is available.

Thanks.