Hi , I am getting to following error after trying to run a MDX Query againt the analysis server on the Execute SQL Task component - SSIS . I was changing the component timeout and the tools>option>bids>analysis timeout . even trying to play with the Server timeout property . Am I missing something ?? didnt find any helpfull stuff on the web . any help will be very appreciated ... [Execute SQL Task] Error: Executing the query "WITH MEMBER [Measures].[6d3dc246-b52e-b37b-6e37-..." failed with the following error: "XML for Analysis parser: The XML for Analysis request timed out before it was completed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Did the same MDX query complete in SSMS? And see if this post has something helpful: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4c919683-fc88-4d51-a265-458dde1e1d22/Arthur My Blog

Have you changed the Query Timeout to '0'?

yep, I've changed it to 0 in the component itself, and to 500 at the SSIS tools>option>bids>analysis .

In ssms you have to change the time out to '0' . Tools>Options>Designers>Analysis Services Designer>General>Timeout to '0'.

I've just changed the ExternalCommandTimeOut into 0 at the server>properties , Did you mean to another property ? Thanks for replying ...

Yes ,Tools>Options>Designers>Analysis Services Designer>General>Query Timeout to '0'.

I have changed it, but still get the time out :-( , what could it be ??

check this http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/efbcba1e-7689-45f9-938f-30e957a001b8

Thanks, but I'm afraid the link you sent relates to running MDX on the SSMS, I am trying to make it run on the SSIS . It does run on my SSMS !!

Simple as that - just creating it from scratch and it works !! Maybe there was garbage behind the problematic package ..