May 27, 2008 at 11:57 pm
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!!!
May 28, 2008 at 5:38 am
There are no triggers in Analysis Services. So, either you need some other plan, or I do not understand what you are trying to do.
As far as using SSIS with Analysis Services. You can execute an MDX statement and return the results into a data flow. The OLE DB Source component does not seem to work well for this, so use a Data Reader Source component. Also, data flow components hate square brackets ([]) in column names (which you probably cannot avoid), so I have found it beneficial to use a type conversion component to simply rename columns - this component worked ok with source columns having square brackets in the column names.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply