Post reply

Send Mail Task

  • March 12, 2008 at 3:07 am

    #121061

    Hi

    I am trying to set up a Send Mail Task in SSIS. The server from which I want to send the mail from has got some security profiles. The information I have is like mail.itmaid.co.za. There is a username and password used to access this server. Is there anyone who can tell me where I'll need to put in these credentials.

    Sello Moloto:hehe:

  • March 12, 2008 at 8:18 am

    #788574

    Why don't you use sendimail_sp built-in stored procedure?

  • March 13, 2008 at 3:32 am

    #788940

    The mails need to be sent via a service account held by some other company.

    If u recommend xp_sendmail, I get the @user not defined message.

    I have created a stored proc which needs the sp_oasetproperty for 'from' and 'to' methods which I don't know, by this I mean, say u want to change properties for mailHost, right? U'd go sp_oaSetproperty @oMail, "HostName", "LocalHost".

    What do I use in place of '?' in

    sp_oaSetproperty @omail, ? , 'me@mycompany.com'

    sp_oaSetproperty @omail, ? , 'someone@somewhere.dom'

Viewing 3 posts - 1 through 2 (of 2 total)

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