Hi,
I would like to process an AS 2000 cube in SSIS.
I'm using the 'Analysis Services Processing Task', but I just get the error 'A connection cannot be made. Ensure the server is running'.
It would be an unfortunate limitation if you can only process 2005 cubes in SISS. Does anyone know if its possible to process 2000 cubes in SSIS?
Many thanks
Jeremy
'Analysis Services Processing Task' works against AS 2005 only. There is no built-in task to process AS 2000 objects.
You can try the Script Task and write code that will send the process request to a AS 2000 server
Regards,
Ovidiu Burlacu
Its quite a clunky, fiddly way to go about things, but if its the only way to do it then so be it
Many thanks
Jeremy
|||I am trying to do the same thing! - we have a 3rd part dw app that uses sql 2000 olap, and will not support an upgrade to 2005 olap. Did you find anything new?
No comments:
Post a Comment