I know how to use wizard for usage based optimization. Does anyone know if it can done through SSIS script task or C#/.net programming object. the reason is that I cant start wizard every time i want to optimize aggregations. we have 50 clients and if I do manually for each client it will take lot of time. instead if i can schedule it through ssis task or code something it will be helpful.
let me know if someone can help me.