Send Mail Task Failed Using SSIS Package

  • I just have created SSIS package with only Send Mail Task Block. But I am facing below error. I have crosschecked My gmail smtp is working fine on test tool but in SSIS package I'm facing the below issues.

    Hey Guys Please help me with This.

     

     

    Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 172.217.194.109:25".

    Task failed: Send Mail Task

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • The most likely cause is that your firewall does not allow outbound connection to the gmail SMTP server. I'm assuming your SSIS package i running in a corporate environment.

    You say that you have verified that your "gmail smtp is working fine on test tool". Did you run that test tool on the SQL Server? That is the only place where you can do an actual verification.

     

  • I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden wrote:

    I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉

    Hmmm... I'm pretty sure that IP address is one of the public smtp addresses used by gmail.com if the OP is to be believed, which means it's already known "out there". 🙂

     

  • kaj wrote:

    Jeff Moden wrote:

    I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉

    Hmmm... I'm pretty sure that IP address is one of the public smtp addresses used by gmail.com if the OP is to be believed, which means it's already known "out there". 🙂

    Thanks, Kaj.  I sure hope you're right.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Hey I don't have firewall in my system. it is my personal laptop and also I have uninstalled antivirus as well but still it is not working.

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

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