I never got this to work within the SSIS package by either using the Send Mail Task or by including a Exec SQL Task which called the sp_send_dbmail proc.

I found...

Thanks Steve... I appreciate the quick reply.

I'm in the process of building a new server as a home to these databases. This is a band-aid... I'm trying...

I thought I would post this for everyone's benefit...

My research indicates that any attempt to use sp_OACreate with a context of 4 (out of process) will fail in SQL Server...

Yes... I'm starting over and rebuilding the server later this week. I'm convinced something was simply 'broken' in the server setup. I just wish I could determine...

Darrell:

Without more information, it's difficult to tell you exactly where to fix this. My guess is this: Although you've restored the database from a backup including the list of...