I want to create a SSIS package to rebuild a measure group for a cube.
I have a fact table the contains a variable number of columns. I can drop the measure group with a DLL task by generating an xmla script from SSMS, but because the measures are not always the same I can not script this task generically. Is there another method to create measure groups in SSIS or can you assist with any other ideas?
thanks
Jason