Does anyone know a way to extract data from Analysis Services 2005
cubes in a SSIS data flow task?

I created an OLE DB source using the Microsoft OLE DB Provider for
Analysis Services 9.0? I then specified the MDX query in the SQLCommand
property.

This looked like it would work - it is possible to see the resultset in
the preview window. When I view the columns tab, I get a load of
warnings saying that it cannot recognise the external data type and
will instead use the data type DT_WSTR. Nonetheless, it possible to
click OK and continue.

However when I run the package, it fails with prevalidation errors.