AUTOMATE PROCESS

Hi

Currentyl after i transfer the data from another database(source) to datawarehouse. I need to click on the "process" button in order to see the latest result. Do it have a command or way to do it programmatically or using the SSIS to do it?

Anyone please point me the link for me to do the automate process ?

Thanks in advance for anyone provide me some clue.

There are plenty of different options

SSIS has an SSAS processing task.

You could script the processing from SSMS as an XML/A command and schedule it from SQL Agent or using the ascmd sample that was released with SP2.

You could write a .Net app using the AMO to initiate the processing.

|||

Hi Darren,

You again . And thank again for the pointing.

And i found more details explaination on this,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230156&SiteID=1

Just provide for those are interested. And is worked and simple.

Thanks

|||Yep me again . That's exactly what I had in mind.