I have one SSIS package in which I am executing one MDX query for getting the record count.
but after executing the task I am getting following error message.
[Execute SQL Task] Error: Executing the query "SELECT
[Measures].[Enroll Row Count] ON COLUMNS
F..." 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.Ani
View Complete Post