SSIS send mail task

1
votes

Due to security policy my client is planning to stop the SQL mail service on the server, in that case will my SSIS mail task work?

Thanks.

2
ssis

2 Answers

3
votes

Yes, your SSIS mail will continue to work.

SSIS mail tasks connect directly to the SMTP server to send messages via the SMTP connection defined in your SSIS package.

1
votes

Send mail task in SSIS will be the best option to use and will have some restrictions but can send a formal mail without any delimiters,HTML tags by providing the SMTP server name