微软BI开拓者

总感觉 SSIS里的 send mail task的设置比较简单。在运行时总是报以下错误


[Send Mail Task] Error: An error occurred with the following error message: "Server does not support secure connections.".

望高人指点。怎样才能发送邮件。

利用脚本任务发送网易163邮箱
以下代码用的是网易163邮箱，认证方式为System.Net.NetworkCredential("用户名", "密码")

Imports System
Imports System.Data
Imports System.Math
Imports System.Net.Mail
Imports System.Net
Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

    Public Sub Main()
        '
        ' Add your code here
        '
        Dim myHtmlMessage As MailMessage
        Dim mySmtpClient As SmtpClient


        myHtmlMessage = New MailMessage("xxx@163.com", " qiangguo@test.com", "Subject", "body")
        mySmtpClient = New SmtpClient("smtp.163.com")
        'mySmtpClient.Credentials = CredentialCache.DefaultNetworkCredentials
        mySmtpClient.Credentials = New System.Net.NetworkCredential("用户名", "密码")
        mySmtpClient.Send(myHtmlMessage)

        Dts.TaskResult = Dts.Results.Success
    End Sub

End Class

参考我的详细文章：
http://blog.csdn.net/guoqiang1983/archive/2008/07/10/2632851.aspx