Hi guys,
I needed to transfer data from an Access db into BPC 5.0.102. For that purpose I created an SSIS package that uses the Admin task to make the application optimization and a SQL task to load data into the WB table of the application.
When I try to optimize the application again the AdminTask gives me a TaskFailed error due to the presence of data on some parent elements.
The question is how can I obtain the error description generated by the AdminTask, if that is possible? When I manually do the application optimization from the Administration Console I get the error with a description saying that I'm trying to write data on a specific member of the specific dimension which is a parent element. Can I obtain this error message from inside SSIS?
Thanks.