July 22, 2022 at 11:33 am
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
July 23, 2022 at 12:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 30, 2022 at 4:33 pm
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.
July 31, 2022 at 7:24 pm
I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security???
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2022 at 6:36 am
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".
August 2, 2022 at 2:16 pm
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
Change is inevitable... Change for the better is not.
August 3, 2022 at 6:59 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy