Thought you all might like to see the solution I built to resolve this issue for myself. It is a composite of code based upon examples from various sources...

Nevermind. I have gone down the path of creating a parent package which programatically builds and executes a child package. This will allow me to build schema independent...

Ok, so this is a HUGE help!  Wonder why my searches on here didn't bring that up?  I will take a look at the solution and see if it takes...

EdVassie, 

That is what I was afraid of.  Thanks for the help.

EdVassie,

Thanks for the reply.  What I am looking for is to truly integrate the Operator with the xp_sendmail's @Recipient value.  Meaning something similiar to teh below that works:

use master

go

exec xp_sendmail...

[banging own head against wall] so quickly I forget about that magical dev language known as vbscript   [/banging own head against wall]

Thanks for...

Just as I was a fraid of.  To use SQL-DMO requires a programming language/compiler to build and execute.  I am looking for a solution that can run as either a...

Kenneth,

that logic sounds perfect.  Now I just have to figure it all out as this is my first project of this nature for SQL.  Everything I have done prior...

I like the sounds of the Combine app.  Too bad I need this sooner rather than later.

Kenneth,

To answer your question.  The flexibility I am looking for is that I would...