如何使用Office 365 smtp配置SSIS发送邮件任务 [英] How to configure SSIS Send Mail Task using Office 365 smtp

问题描述

如何使用Office 365 SMTP配置SSIS发送邮件任务

解决方案

您无法使用"发送邮件任务"作为"已发送邮件"任务所需的基于Windows身份验证的  ; SMTP。

对你来说，选项是

1。使用Script Task并使用SmtpClient类初始化和发送邮件

2。使用sp_send_dbmail系统过程使用SQLServer发送邮件。您需要为此设置数据库邮件

这两者都在此处指定

https://social.msdn.microsoft.com/Forums/sqlserver / en-US / 1d527cab-370b-4cb2-a0eb-3d754f23a39e / ssis-email-task-office-365？forum = sqlintegrationservices

要为office 365设置数据库邮件，请参阅

https://blogs.msdn.microsoft.com/momalek/2013/02 / 25 / how-to-configure-sql-database-mail-so-send-emails-using-office-365-exchange-online-a -throughthrough /

How to configure SSIS Send Mail Task using Office 365 SMTP

解决方案

You cant use Send Mail Task for this as Sent Mail task required windows authentication based  SMTP.

For you the options are

1. using Script Task and use SmtpClient class for initializing and sending mail

2. using sp_send_dbmail system procedure to send mail using SQLServer. You need to set up database mail for this

both are specified here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1d527cab-370b-4cb2-a0eb-3d754f23a39e/ssis-email-task-office-365?forum=sqlintegrationservices

For setting up database mail for office 365 see

https://blogs.msdn.microsoft.com/momalek/2013/02/25/how-to-configure-sql-database-mail-so-send-emails-using-office-365-exchange-online-a-walkthrough/

这篇关于如何使用Office 365 smtp配置SSIS发送邮件任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！