Post reply

SSIS package to send an e-mail

  • February 3, 2010 at 8:54 am

    #156641

    Hi,

    I want to create a SSIS package to send an e-mail upon completion.

    The problem is my SMTP server is not windows and requires a username and password.

    Is there a way to include the username and password in the SMTP send mail task?

  • February 3, 2010 at 9:56 am

    #1113029

    Short answer, you can't. At least not out of the box.

    The important sentence:

    "The SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication."

    http://msdn.microsoft.com/en-us/library/ms137684.aspx

    You could potentially use a Script Task to do it.

    CEWII

  • February 4, 2010 at 10:31 am

    #1113867

    mukisql2008 (2/3/2010)

    Hi,

    I want to create a SSIS package to send an e-mail upon completion.

    The problem is my SMTP server is not windows and requires a username and password.

    Is there a way to include the username and password in the SMTP send mail task?

    You can use SSIS script to accomplish this. Check this script for reference.

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

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

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