BPC 75 send mail 2008 task

[Former Member]

Hi Guru,

I need to develop the send mail 2008 SSIS task on SQL server 2008.

Do you have some information about it? which parameter I need to set as minimum?

Regards

Marco

[former_member186498 · Accepted solution]

Hi Marco,

the same info required for a mail plus the appset and the server\userid.

Kind regards

Roberto

[Former Member · Accepted solution]

Did you mean the parameter I set in the "Application Set" parameter?

e.g.

SMTPSERVER

SMTPUSER

thanks in advance

[former_member186498 · Accepted solution]

Hi Marco,

you asked about the send mail 2008 SSIS task, in this task you must set "appset" and "server\userid" that send the email plus the "TO", "Message".

"Subject" "Attachments" etc. are optional.

Of course before you must set all the smtp parameter to the "Appset parameters" i.e. SMTPAUTH, SMTPPASSWORD, SMTPPORT, SMTPSERVER and SMTPUSER.

Kind regards

Roberto

Edited by: Roberto Vidotti on Dec 14, 2011 9:47 AM

[Former Member]

Hi,

You need to properly define the appset parameters - SMTPAUTH, SMTPPASSWORD, SMTPPORT, SMTPSERVER, and SMTPUSER for setting up the email functionality.

Hope this helps.