Failure in Send mail task-ssis package can't find smtp server

Question

Post reply

Failure in Send mail task-ssis package can't find smtp server

neilnewton001

Mr or Mrs. 500

Points: 503
More actions
October 3, 2009 at 12:28 pm

#134275

Hi,
Very new to SSIS. I have set up a simple package that ends with sending me an email just to test the email functionality. I've setup a send mail task to do this. I've tried simply putting in the ip address of the smtp server in the send mail task properties and also creating an smtp connection manager and using that to connect in the send mail task.
I got the address from going to my ssrs configuration tool and copying the email smtp ip address from there. ssrs saves the ip address without a colon between the ip address and the port. I tried in that way, I tried it with the colon, both of these in the send mail task properies and the smtp connection manager. I tried it with windows authentication turned on and off and with enable ssl on and off. Nothing works.
I always get an error. If I put the ip address directly into the properties of the send mail task it tells me it can't find the smtp server with the address I've given. In case it's important, I'm running this from my development server, not the ssis server; i figure it should still be able to find the smtp server from the dev server, especially if I'm using an ip address and not a name.
Any advice would be appreciated.
Thanks,
Fig

Viewing 6 posts - 1 through 5 (of 5 total)

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

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

What is the error message you get?

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

neilnewton001 Mr or Mrs. 500 Points: 503 More actions · Answer 2

CozyRoc,

Thanks for answering. I started out putting the ip address directly into the properties of the send mail task. In that case I got the message:

The connection "IP Address:Port" (I put in real numbers 🙂 is not found. This error is thrown by Connections collection when the specific connection element is not found.

That was with this ip and port directly in the smtp connection property of the send mail task. I then tried to create an smtp connection with the same ip address and port. At that point the error became "Failure Sending mail".

I then put the mail sending code into the script component and I got another "Failure sending mail".

I figured the last two errors were caused by the inabillity to find the ip address though that may have been naive.

I verified the ip address of the smtp server by looking at the address used (successfully) in our SSRS report server configuration.

Any ideas?

Thansk,

Fig

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

In the Send Mail Task you have to specify SMTP connection. You cannot directly type in IP/port. Have you tried specifying only IP address without port? Also in your SSRS from where you took the information, how does it authenticate with the SMTP server? Does it use windows authentication, anonymous or it expects username and password?

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

neilnewton001 Mr or Mrs. 500 Points: 503 More actions · Answer 4

I've tried just putting in the ip address right into the property of the send mail task without a port; in fact that was the first thing I tried and it didn't work. I am told by our admin that the smtp has no authentication, though I'm not sure. When i looked at the email section of my ssrs config tool there was only an ip address and port with a space between them. The two other fields is a sender address and a current delivery method (set to "use smtp server"). There weren't any fields for authentication.

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

neilnewton001 (10/6/2009)
I've tried just putting in the ip address right into the property of the send mail task without a port; in fact that was the first thing I tried and it didn't work. I am told by our admin that the smtp has no authentication, though I'm not sure. When i looked at the email section of my ssrs config tool there was only an ip address and port with a space between them. The two other fields is a sender address and a current delivery method (set to "use smtp server"). There weren't any fields for authentication.

It is quite possible it uses windows authentication. If that is the case you have to make sure the user account you use under SSIS has similar permissions like the account you use to run SSRS. When you are testing in Visual Studio the account used is the account you are currently logged on. Ask your admin if your account has permissions to access the SMTP server.

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