October 26, 2015 at 12:21 pm
I'm a beginner with SSIS/SSAS and I have an SSIS package that contains some SSAS processing tasks. However, when some of the SSAS processing tasks fail when the SSIS package is run, there are no error messages appearing in the Error List window. Does anyone have any ideas as to where the error messages for this failed SSAS processing task(s) can be found? Any help would be appreciated.
October 27, 2015 at 4:11 am
Depending on how your instance is set up, you can find this information in a number of places. Have a look at the following article: http://blogs.msdn.com/b/as_emea/archive/2012/01/02/initial-data-collection-for-troubleshooting-analysis-services-issues.aspx
October 27, 2015 at 4:20 am
Also keep in mind that sometimes SSAS displays its most crucial error information in warnings, instead of actual errors.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2015 at 7:09 am
Ok, thanks for the link! I ended up trying to process the cube seperately which allowed me to see what was causing the problem. But I'm still a bit curious whether SSIS displays the error/warnings anywhere. I will check out the link. Thanks for your response.
October 28, 2015 at 7:11 am
Thanks for the response. As I recall though, I don't believe there were any messages listed as warnings either. I will keep that in mind though for the future to make sure I didn't overlook anything. Thanks for the tip.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply