Error Using "Send Mail Task" - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Error Using "Send Mail Task"

Author

Topic

Tyecom
Starting Member

12 Posts

Posted - 2008-01-16 : 13:57:54

I'm trying to send a email to myself when my DTS package has successfully been executed or failed. However, my "Send Mail Task" will not execute successfully, not even in BIDS. I don't see any error messages, however, I do remember seeing something about "Server Authenication Required". I'm at work on the company's network and using MS Outlook 2003. I have no problems sending and recieving mail through Outlook. I went into Outlook to find my companys' SMTP server name and entered that info in the SMTP Connection Manager Editor, with the "Use Windows Authenication" button checked. But it still do not run successfully. I get the same error at home on my own computer. Can't figure it out!

When using "Send Mail Task" is there any other configuration required in BIDS to activate sending mail out or is there something I'm missing in configuring SMTP Connection Manager? Please advise. Thank you in advance.

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-01-16 : 14:33:08

Uncheck "Server Authenication Required"

Tyecom
Starting Member

12 Posts

Posted - 2008-01-16 : 17:57:42

Unchecking "Server Authenication Required" did not work.

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-01-18 : 14:11:03

quote:
Originally posted by Tyecom

Unchecking "Server Authenication Required" did not work.


Try this and see...

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

Public Class ScriptMain
    Public Sub Main()
        Dim msg As MailMessage
        Dim smtp As SmtpClient

        msg = New MailMessage("emailme@mail.com", _
                              "emailme@mail.com", _
                              "My subject here", _
                              "Mail body here")
        smtp = New SmtpClient("YOURSMTP")
        smtp.UseDefaultCredentials = False '<<<< credential might be the culprit
        smtp.Send(msg)
        Dts.TaskResult = Dts.Results.Success
    End Sub
End Class

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources