locked
To Send mails RRS feed

  • Question

  •  

    Sir,

    My task is to trigger mails automatically based on  KPI status in the Cube (Database).We have an option to customise mail service in SSIS(SQL Server Integartion Services) and by doing so manually giving To and From mail address i could send mails but my intention is to get the mail ids from the Cubes( developed using SQL Server Analysis Services)and i need to trigger mails from SSIS package.
    For doing so, do i have any option to get Email ids from cubes and pass it to SSIS package and send mails to many respective  reciepients..

    Can u suggest any necessary solution...

    Looking Forward To An Early Reply..

    Thanks In Advance!!!
    Friday, May 30, 2008 7:07 AM

All replies

  • Hi sravan,

     

     You are coreect SSIS has Send mail task where you create task.

     

    Can you provide some more information abt the cube . does your cube has any table with col having E-mail ID's

     

    some thing like tht .

     

    Thanks,

     

    Friday, May 30, 2008 1:56 PM
  • Hi

     

    You can use OLE DB source using OLE DB Provider for analysis services in SSIS to extract data (mail ids) from cube, instead of SQL Query you can use MDX Query to select mail ids. 

     

    then you can use SSIS send mail task to send mails.

     

     

    Friday, May 30, 2008 5:17 PM