Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Staging data and sending notification e-mail messages

Answered Staging data and sending notification e-mail messages

  • Tuesday, January 31, 2012 7:12 PM
     
     
    Sign In to Vote
    0

    Hi,

    I was wondering if it's possible to send e-mail notification messages when data is staged and validated (udpValidateModel) automatically by SSIS as how you will do this within the user interface? Can this be used together with change tracking groups (when a value changes then send an e-mail)?

    Thank you in advance.

    Regards,

    Johan Machielse

     

All Replies

  • Wednesday, February 08, 2012 8:20 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Johan,

    Master Data Services can be configured to send e-mail notifications automatically. You configure notifications in Master Data Services Configuration Manager. Notifications send mail by using Database Mail on the instance of SQL Server Database Engine that hosts the Master Data Services database.

    For more information about Database Mail, see Database Mail Configuration Objects
    For more information about How     Configuring Email Notification, see Configuring Email Notification

    Thanks,
    Challen Fu

    Challen Fu

    TechNet Community Support

     
  • Wednesday, February 08, 2012 11:13 AM
     
     Answered
    Sign In to Vote
    0

    Hi Johan,

    we will configure the notifications in MDS configuration manager.

    Notifications send email messages by using Database Mail on the instance of SQL Server Database Engine that hosts the Master Data Services database.

    Notifications are sent in the following instances when

    Model version status changes

    Data fails business rule validation

    please go through this links

    http://technet.microsoft.com/en-us/library/ms175100(SQL.110).aspx

    http://blogs.msdn.com/b/mds/archive/2010/02/17/enabling-human-workflow-part-3-configuring-email-notification.aspx

    mark as answered or vote as helpful if it meets your requirement

    s dhwani


     
  • Thursday, February 09, 2012 9:27 AM
     
     
    Sign In to Vote
    0

    Hi,

    Thank you for your answers.

    So, when I validate my model using SSIS/T-SQL (udpValidateModel), and everything is well configured, e-mail notifications will be sent right?

    Regards,

    Johan Machielse

     
  • Thursday, February 09, 2012 1:23 PM
     
     
    Sign In to Vote
    0

    Hi Johan,

    Email notifications are sent in the scenario's which I mentioned in the above thread.

    mark as answered or vote as helpful if it meets your requirement

    s dhwani