ssis send mail task-package can't find smtp server ip address

[fig000]

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.If i use smtp
connection manager I just get told that the send email failed. I
figure it's for the same reason though it's hard to tell. The
eventview usually just tells me the package failed.



I've seen stuff about mcafee block my access and even something about
outlook (which I assume is connected to the smtp server but not the
same thing.



Any advice would be appreciated.

Thanks,
Fig

[Todd C]

Hello Fig:
I hear your frustration.

I would stick to defining a Connection Manager and referencing it in the
Send Mail task. I have my SMTP Connection Manager set up as follows and it
works OK for me: SMTP Server: <servername>.<domain name>.com, with Windows
Authentication turned on and SSL off.

If all else fails, try pinging the Server.Domain.Com entry you are using.

HTH
=====
Todd C

Post by fig000
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.If i use smtp
connection manager I just get told that the send email failed. I
figure it's for the same reason though it's hard to tell. The
eventview usually just tells me the package failed.
I've seen stuff about mcafee block my access and even something about
outlook (which I assume is connected to the smtp server but not the
same thing.
Any advice would be appreciated.
Thanks,
Fig