SSIS Package sending Email to an Outlook Group using [dbo].[sp_send_dbmail]

Bobby P 221 Reputation points
2020-12-16T14:51:10.97+00:00

We have a SSIS Package that runs complete and successfully...the last step sending an informative Email via a Control Flow Task, Execute SQL Task using [dbo].[sp_send_dbmail]

Strangely enough, I, personally, am getting this Email everyday using my personal Email Address. However, we are also including an Outlook Group on this Email and they do not seem to be getting it everyday.

So I'm not sure if this is a SSIS problem, a SQL Server problem using [dbo].[sp_send_dbmail] issue, or and Outlook issue at this point.

Has anyone ever experienced anything like this before?

Thanks for your review and am hopeful for a reply.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,653 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,872 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jeffrey Williams 1,886 Reputation points
    2020-12-16T22:33:31.463+00:00

    SQL Server database mail sends mail to an SMTP server - which then forwards that mail to your Outlook (Exchange) system. In order for SMTP to be able to send an email there must be a valid email address.

    An Outlook Distribution List or Group does not have an email address by default - you have to set it up to allow external senders.

    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2020-12-17T03:08:04.957+00:00

    Hi @Bobby P ,
    1.We have a SSIS Package that runs complete and successfully...the last step sending an informative Email via a Control Flow Task, Execute SQL Task using [dbo].[sp_send_dbmail]
    a. Could you please share the example of the sql query about [dbo].[sp_send_dbmail] in Execute SQL Task?
    b. Please check if you add correct group in the sql query.

    2.Strangely enough, I, personally, am getting this Email everyday using my personal Email Address. However, we are also including an Outlook Group on this Email and they do not seem to be getting it everyday.
    a. Please check if you have permission to send mail to this Outlook Group.
    b. May I know if you try to send mail to this Outlook Group in Outlook Application?

    3.sp_send_dbmail [ [ @Anton _name = ] 'profile_name' ]
    [ , [ @recipients = ] 'recipients [ ; ...n ]' ]
    [ , [ @vadim _recipients = ] 'copy_recipient [ ; ...n ]' ]

    Please refer to sp_send_dbmail (Transact-SQL).

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?