February 3, 2015 at 11:18 am
Hello,
I am having some difficulties for SSIS send mail task. In my ssis package I have 3 containers which runs one after another and sends email when each container is done( success/fail). Now since we moved to cloud for exchange server I am having issue when first container is done it failed to send success email but other 2 pass to send me email.
Error: 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 (IP)".
This is the error I am getting.
Thanks
February 3, 2015 at 1:45 pm
Seems like connection issues.
Did you say the other two containers did send emails?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 3, 2015 at 4:13 pm
Yes, it does. So there is only one data source for smtp connection. It works for other 2 but not for the 1st one.
Thanks
February 4, 2015 at 12:42 am
Maybe there something wrong in how you configured the 1st task.
Do you use any configurations or expressions?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2015 at 10:36 am
No I am not using any configuration.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply