Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute the XMLA code through SSIS package Expand / Collapse
Author
Message
Posted Monday, July 7, 2014 6:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:26 AM
Points: 56, Visits: 249
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.


  Post Attachments 
Task.jpg (3 views, 17.55 KB)
XMLA.jpg (3 views, 63.94 KB)
Post #1589819
Posted Friday, July 11, 2014 12:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:26 AM
Points: 56, Visits: 249
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.
Post #1591462
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse