How to run XMLA in SSIS that has a return result
-
Friday, August 03, 2012 6:46 PM
Hi all i have a XMLA that has a XML return result
what i want to ddo is to run the XMLA , get the results and clean up the unwanted data, and save it into a sql table, i will have to do this in SSIS, without running and 3rd party component or installing anything else
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions>
<RestrictionList>
<ObjectExpansion>ObjectProperties</ObjectExpansion>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Format>Tabular</Format>
</PropertyList>
</Properties>
</Discover>Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
All Replies
-
Friday, August 03, 2012 9:04 PMModerator
Maybe something with a Script Task?
http://technet.microsoft.com/en-us/library/ms123481and an example of execute reader (instead of the ExecuteNonQuery example on msdn):
http://www.yaldex.com/sql_server/progsqlsvr-CHP-20-SECT-6.html
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Proposed As Answer by btsbee Monday, August 06, 2012 10:22 AM
- Edited by SSISJoostMicrosoft Community Contributor, Moderator Monday, August 06, 2012 10:28 AM
- Marked As Answer by Nik - Shahriar Nikkhah Tuesday, August 07, 2012 1:04 PM
-
Tuesday, August 07, 2012 1:04 PM
Hi SSISJoost
I did look at athe links I feel that they are right, it doesn't have a sample with a return results, that is something that i will have to find out
thanks
Nik
Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
.png)
