SSIS Dynamic SMTP Mail Server

SSIS dynamic SMTP mail server

Hi All,

I'm trying to make my SEND MAIL TASK in SSIS dynamic, by retrieving SMTP Server name (amongst other email message information) from a table.

I've got an SP that is getting the information into package variable's, and when I don't try and have a dynamic server name (i.e. I use a specified SMTP server in my SMPT Server connection), then the email get sent off.

I'm trying to use an expression to build alter the send mail to use the server name I have in a user variable.

I've tried using the expression for the property:
SmtpConnection set to: RTRIM( @[User::MailServer])

I also tried without the RTRIM - I only added it because the error messages seem to include a full 'string' length, and there doesn't seem to be a 'varchar' data type for SSIS variables.

so:
a> Is SMTPConnection the property I need to be setting? None of the others seem correct
b> If SMTPConnection IS the property I need, does the value give the SMTP Server Name, or just the Name of the connection from the Connection Manager's?

Thanks


Part-Answer to:
b> The SMPTConnection property sets the name of the CONNECTION to be used. That Connection needs to set the name of the server. So n ow, the question becomes, how do I configure that from SQL (I know how to use package configurations from XML files).