Post reply

Setup Send Mail task

  • November 22, 2010 at 4:14 pm

    #229542

    Could anyone give me tips how to setup Send Mail task at home using just an Internet provider?

    Thanks.

  • November 23, 2010 at 3:51 am

    #1254299

    Please follow here

    Raunak J

  • November 23, 2010 at 7:43 am

    #1254466

    Thanks for the info.

    I do not have Exchange server nor Outlook, do I have to install them.

    All my email activities are on the Internet provider server.

    Thank you again.:unsure:

  • November 23, 2010 at 11:55 am

    #1254658

    I don't think it is possible. You can specify the SMTP server, but the SMTP Connection Manager in SSIS only support anonymous or Windows authentication. And I don't think your Internet Provider gives you these options 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 23, 2010 at 12:58 pm

    #1254690

    Merci.

  • November 23, 2010 at 10:12 pm

    #1254883

    sqlgreenhand (11/23/2010)

    Thanks for the info.

    I do not have Exchange server nor Outlook, do I have to install them.

    All my email activities are on the Internet provider server.

    Thank you again.:unsure:

    You can implement script to send emails thru SMTP and provide username and password. Check here for reference.

    For more advanced functionality, you may also check the third-party commercial CozyRoc Send Mail Task Plus.

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

  • November 24, 2010 at 3:40 pm

    #1255368

    Thank you for the response.

    As a "green hand", I have questions

    What is the extension"STX" for the two scripts file (05/08)?

    Also, is "Script task plus" a must to run the original script !?

    My SMTP connection from the Internet provider is "smtp.xxxxx.xxxx.com", is this to

    replace

    <Description("Specifies the name of the SMTP connection manager.")>

    to become

    <Description("smtp.xxxxx.xxxx.com")>

    ?

    After replacing with the real connection content, this piece of code will be added to the

    "add code here" under the "Script task" instead of using the original "Send Email task" !?

    Sorry for so many questions.

    Thanks.:cool:

  • November 24, 2010 at 3:48 pm

    #1255370

    sqlgreenhand (11/24/2010)

    Thank you for the response.

    As a "green hand", I have questions

    What is the extension"STX" for the two scripts file (05/08)?

    Also, is "Script task plus" a must to run the original script !?

    My SMTP connection from the Internet provider is "smtp.xxxxx.xxxx.com", is this to

    replace

    <Description("Specifies the name of the SMTP connection manager.")>

    to become

    <Description("smtp.xxxxx.xxxx.com")>

    ?

    After replacing with the real connection content, this piece of code will be added to the

    "add code here" under the "Script task" instead of using the original "Send Email task" !?

    Sorry for so many questions.

    Thanks.:cool:

    The .STX is the extension for scripts which are used with the commercial CozyRoc Script Task Plus. One script is for SQL 2005 and the other for SQL 2008.

    However you can most of the script logic without a need to purchase CozyRoc's product. That's why I mentioned you can use the script for reference. But you have to have programming skills to do the modifications.

    The commercial Send Mail Task Plus doesn't require programming skills, but you have to purchase it.

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

  • November 24, 2010 at 5:06 pm

    #1255403

    Thanks Master CozyRoc.

    :satisfied:

Viewing 9 posts - 1 through 8 (of 8 total)

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