Post reply

Problem with Send Mail task

  • November 17, 2008 at 2:48 pm

    #201449

    Hello All,

    I have an SSIS package which sends e-mail to a distribution group using Send Mail task. The distribution group name is 47 bytes in length and has 5 e-mail addresses. The package runs fine and sends e-mail succesfully when ran independently. However I'm receiving the following error when ran from the parent package. I verified the parent package variable that is passed to child package, the variable is used in ToLine expression in Send Mail task, and the email address being passed is valid.

    Send Mail Task: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".

    Could anyone please let me know what could be the reason for failure when the package is executed from parent package.

    Thanks,

    -Amith Vemuganti

  • November 19, 2008 at 7:07 am

    #900496

    Amith,

    Can you create a script task in the second package, being executed with a script which shows MsgBox of the variable containing the ToLine value? Let's say if the variable is passed correctly.

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

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

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