I prefer to use logging table as I need to collect events I need from multiple components or even packages and report it at scheduled time.

the problem for this script is that instead of using ssis components for email, we have to use senddbmail which mean setting a mail profile at database is a must.

is there any way to use ssis mail task with body contains html formatted strings?