i have problem with SSIS, Send Mail Task.
What the difference between Send Email using Database Mail and Send Mail task?
Because with Database Mail i can send test email successfully. And can get email using msdb.dbo.sp_send_dbmail.
But when i type SMTP Server on SMTP Connection Manager i get error.
Sending duration is ~10 seconds and error: 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 [IP]."
It maybe problems because of firewall? But why i can send email through Database Mail?
View Complete Post