I am currently attempting to add an Analysis Services Processing Task to my SSIS Designer to be able to process the cube. In my current Analysis Services I have 3 databases (ApShell , ApShell_NLB and AGC_Prod). I want to go ahead and create the processing task in SSIS for the cubes inside my AGC_Prod database. When I go inside the “Analysis Services Processing Task Editor” and go to “Add Analysis Services Object” I can only see the ApShell object. I do not see AGC_Prod which is the one I want to select to process the cube. The ApShell_NLB does not show up either. Although I do not need that one. I have compared the setting on the Analysis Services DB’s and do not see a difference. Any help with being able to see my Analysis DB (AGC_Prod) in the “Add Analysis Services Object”?
OS: MS Windows Server 2003 Ent. 64-bit SP2
SQL: SQL Server 2008 Ent. 2008