Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 To Send Mails

Author  Topic 

sravan1729
Starting Member

5 Posts

Posted - 2008-05-28 : 01:51:12
Sir,

My task is to trigger mails automatically based on status in the 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!!!
   

- Advertisement -