SP_Send Mail sends duplicate mail

  • Hi,
    I am using recipient, looping from a user table as @recipent
    And add BCC also in the sp send mail.

    so while executing this query from SSIS execute task, duplicate mails are triggering to recipient

    Need urgent help

  • malakar02amit - Saturday, September 29, 2018 5:15 PM

    Hi,
    I am using recipient, looping from a user table as @recipent
    And add BCC also in the sp send mail.

    so while executing this query from SSIS execute task, duplicate mails are triggering to recipient

    Need urgent help

    Sounds like you have an issue is with your code that we can't see. In the future you may want to include that when wanting urgent help.

    Sue

  • Sue_H - Monday, October 1, 2018 11:03 AM

    malakar02amit - Saturday, September 29, 2018 5:15 PM

    Hi,
    I am using recipient, looping from a user table as @recipent
    And add BCC also in the sp send mail.

    so while executing this query from SSIS execute task, duplicate mails are triggering to recipient

    Need urgent help

    Sounds like you have an issue is with your code that we can't see. In the future you may want to include that when wanting urgent help.

    Sue

    As Sue said... And include DDL and sample data (please scrub so the real emails don't get harvested and used by web bots) for a better answers. We can't see through your eyes, unfortunately.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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