Executing MDX Queries in SSIS 2005

Anyone who has not delved deeply into SSIS, like me, would think that this task should be a fairly straight forward exercise. Using an OLE DB provider for MSOLAP and entering the MDX query in place of the T-SQL query I expected SSIS to output the results of the query. Oh how wrong I was.