July 7, 2014 at 6:10 am
We have a table column that has a column with XMLA code as shown in XMLA figure. I am using a E-SQL task with a full result set mode and a variable(query variable) of type object to store all the xmla queries from the table.
I have a For each Container loop next to it. The input will be "Foreach ADO Enumerator" plus rows in the first table. Plus I have the query variable configured to it.
In the variable Mapping of For each loop container I have the query variable with index 0 assigned to it.
However the package runs to success but the Execute DDL command does not turn gets exected as a result it is like the way shown in Task figure.
Please help me understand what am I missing ? Should I use a Script task to execute the xmla code one by one ? Please guide me.
July 11, 2014 at 12:53 am
The Execute DDL tasks fails and I get the error message like this:
[Analysis Services Execute DDL Task] Error: The System.__ComObject text node at line 7, column 34 cannot appear inside the Command element (namespace urn:schemas-microsoft-com:xml-analysis) under Envelope/Body/Execute. This element can only have text nodes containing white-space characters.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply