Skip to Content
0
Former Member
Dec 02, 2008 at 03:42 PM

Admin Task - Optimization application

45 Views

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.