not sure if this is the right thread for this, but does anyone out there know how to automate the cube build in transformer from SQL Server? We have an ETL process that runs on SQL server and would like to somehow kick off the cube builds when the ETL process is complete. Our DBAs currently have to log on to the server and manually kick off a batch file which then updates all the cubes. Any help would be appreciated.
Thanks
Jeff
I'm assuming you're doing ETL with DTS, the built in SQL Server ETL tool? If so, you can execute a command line / batch file from DTS directly. When you created your DTS, you likely chained tasks to run in sequence, etc, right? So at the very end, you can have it execute a batch file that kicks off the cube builds.
We have also created an e-mail notification at the end of our ETL so that the admins are notified when things are finished, etc.