Post reply

Getting return code indicate success/fail sending mail

  • July 19, 2006 at 9:09 pm

    #67568

    Hey,wanna ask if anybody know how to get the return code or any confirmation that indicate the success/fail of sending a mail using SendMail task in DTS?For a DTS SendMail task,even it is success in execution of the task,it doesn't mean it successful sending out an e-mail rite?So I would truely appreciate if anybody willing to help me out here,thnx!!!

  • July 21, 2006 at 7:37 am

    #650685

    Hi

    Can't help you with the send mail task...But I have a stored procedure that sends mail through smtp and returns if the mail was sent...as far as the smtp server....Would this help...

     

    Mike

  • July 21, 2006 at 10:39 am

    #650794

    If the send mail task can successfully send an email, it will return Success.  If the mail server is unavailable or you try to send mail from an account you don't have the rights to send emails from, it will return Failure.

  • July 21, 2006 at 11:40 am

    #650814

    Are you looking for a return receipt type option beyond the task success/fail?

    Regards,
    Matt

  • July 22, 2006 at 6:19 am

    #650915

    But the problem is I dunno how or wat the function name to call so tat it will return the code. Can u show me the function to do so?

  • July 22, 2006 at 6:24 am

    #650916

    Thnx Mike,i would like to hear about it....Sry to ask tat can u explain ur method in more simple way when u reply,coz im new to Microsoft SQL server 2000,and how do I set up the mail as smtp while I m using MAPI.Thnx again in advanced

  • July 22, 2006 at 6:38 am

    #650918

    Yaya,coz task success/fail doesn't really mean my mail is sent out. But I think every mailing function have a return code indicating success/fail sending mail out, juz that I need to know how to call it. If only I know the code of the DTS MailSend Task, then maybe I can find out how it works

  • July 24, 2006 at 12:15 am

    #650981

    Hi Jeffry

     

    I have having touble posting the stored procedure. I can email it to you and you can post it on the site...

     

    Regards Michael

  • July 24, 2006 at 12:52 am

    #650984

    Oh thnx...so I'll pm you my e-mail address....really thnx alot ya

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply