I have a BI procedure that performs actions, generates a log, and then tries to email the log. I have attempted to use the Send Email Task, but it has limitations. There is no way to specify the logon parameters for the server (which is a pretty dumb limitation). So, this task will not work, since my server requires authentication.
I have tried using the Notify Operator task. This works (sends a message), however I do not see a way to make the message text come from a variable. I tried setting Expressions but the editor won't accept any syntax when I try and set message=variable.
Is there a way to send an email from a BI procedure where the message text comes from a variable, and the server being used required authentication?