Post reply

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

  • 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

  • October 6, 2009 at 5:40 am

    #1062171

    What is the error message you get?

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

  • October 6, 2009 at 6:47 am

    #1062202

    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

  • October 6, 2009 at 7:07 am

    #1062216

    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/

  • October 6, 2009 at 12:42 pm

    #1062413

    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.

  • October 6, 2009 at 12:55 pm

    #1062422

    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/

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

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