Hey Experts,
I am trying to build an SSIS package to optimize a BPC application using the Admin Task tool. I am enter the AppSet and Server\UserID. I select my Application in the application box.
I am simply trying to select 'Full' as my 'Optimize method'. However, I do not want to do a 'Compress database'. When I close the admin task and go back into editing the admin task, I see that the 'Compress Database' box is checked. It appears that if I uncheck the box and close and run the SSIS package, it appears that the package is doing the full optimization, but it still compresses the main fact table even though I unchecked the 'Compress Database' box.
Why is the AdminTask in SSIS checking the 'Compress Database' box even though I am checking it off? How can I do a Full Optimization without a 'Compress Database' in SSIS?
Any help is appreciated.
P.S. We're running BPC 5.1 with SQL Server 2005.