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).

Maybe something with a Script Task? http://technet.microsoft.com/en-us/library/ms123481 and 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

Maybe something with a Script Task? http://technet.microsoft.com/en-us/library/ms123481Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

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 NikSincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).