Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to work the send mail task and how to access the gmail smtp server

Answered How to work the send mail task and how to access the gmail smtp server

  • Friday, December 14, 2012 4:27 AM
     
     
    Sign In to Vote
    0

    Hi All,

    i have created the send mail using ssis 2008 but that is not working fine because my office didnt have own website only using gmail accounts.

    that means, creating group mail using gmail mail server so didnt support the gmail smtp server.

    send mail task fails, reason is smtp.gmail.com - this is not supported to my office..

    here i have mentioned the error, what is the solution for this one.

    Error --
    gmail won't allow unauthenticated users to send mail, so you would either need an smtp server that allows message relay, or if you have to send via gmail, you will need to write a script component using the system.net.mail namespace.

    what is the solution for this above errors and how to access the gmail smtp server..

    am waiting for U...........

    Regards,

    Abdul Khadir

     
     

All Replies

  • Friday, December 14, 2012 6:04 AM
     
     
    Sign In to Vote
    0

    you cannot directly use SMT for sending mail to gmail: Check this

    http://www.codeproject.com/Articles/85172/Send-Email-from-SSIS-with-option-to-indicate-Email

    http://kalyan-coldfusion.blogspot.in/2012/04/send-email-with-ssisdatabase-from-gmail.html

    Regards,Eshwar.

    --Please use Marked as Answer if my post solved your problem and use Vote As Helpful if the post was useful.

     
  • Friday, December 14, 2012 6:36 AM
     
     Answered
    Sign In to Vote
    0

    Hi Abdul,

    The Send Mail Task in SSIS only supports basic authentication. You cannot send mails using POP3/IMAP protocols, nevertheless, there are custom tasks availble or you may script your own custom task using either the Script Task of create a new SSIS task all together,

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

     
  • Friday, December 14, 2012 6:38 AM
     
     
    Sign In to Vote
    0

    See this:

    http://consultingblogs.emc.com/jamiethomson/archive/2006/07/03/SSIS_3A00_-Sending-SMTP-mail-from-the-Script-Task.aspx

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

     
  • Friday, December 14, 2012 10:38 AM
     
     
    Sign In to Vote
    0

    you cannot directly use SMT for sending mail to gmail: Check this

    http://www.codeproject.com/Articles/85172/Send-Email-from-SSIS-with-option-to-indicate-Email

    http://kalyan-coldfusion.blogspot.in/2012/04/send-email-with-ssisdatabase-from-gmail.html

    Regards,Eshwar.

    --Please use Marked as Answer if my post solved your problem and use Vote As Helpful if the post was useful.

    Hi,

    i am using this link, same script i done but some error comes.

    http://kalyan-coldfusion.blogspot.in/2012/04/send-email-with-ssisdatabase-from-gmail.html

    Errors- Error: The script returned a failure result.

    what is the solution for this error.

    Regards,

    Abdul Khadir.

     
  • Saturday, December 15, 2012 5:44 PM
     
     Answered
    Sign In to Vote
    0

    Hi Abdul,

    The standard Send Mail Task doesn't support gmail. If you can use third-party solutions, check the commercial COZYROC Send Mail Task Plus. It supports gmail SMTP and provides many other useful additions. The task is very easy to use.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/