Debbie Edwards (6/21/2012)
Koen Verbeeck (6/15/2012)
Can you send a screenshot of the package and of the configuration of the tasks? Grey out all sensitive data.I have 2 threads open on this site and the Microsoft forums so I thought I had better update them both
Ive been pulled over to something else this week but I still have the exact same problem
The Analysis Services section of the IS package fails every night, I have to run it manaully on Full which is fine.
My user tried to open a report this morning and got the error
An error occured during local report processing
Query execution failed for data set......
The Sen cube either does not exist or has not been processed
When I have finished what Im doing at the moment I can get cracking again and try and get it sorted but Im worried that its going to be beyond my expertise which is ridiculous sicne it should be easy to set up.
Again Im not sure what you mean by screenshotting the package and task configuration?
You have an SSIS package, so take a screenshot of the control flow and a screenshot of the editor of every Analysis Services Processing Task.
It is not normal that it fails in SSIS and succeeds in BIDS. There must be some underlying issue.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP