[ForcedSterilizationsForAll]

I'm trying to use a Hyperion Essbase as a datasource for SSIS. My google-fu is proving worthless as most of the stuff I'm finding is filler/spam/job board junk.

Currently, we are using the Hyperion cube to load the data into an Excel file. We then load the Excel file into SSIS. Everything is great and peachy, but I'd really love to be able to automate things a little more as it would make life easier for nearly everyone involved.

The only information I've come across on how to do this is that there is some third party tool (but I can find no information on this) and apparently Star Analytics can do this (again, I've found no information on how to do this).

Thanks.