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.

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