process 2000 cube from SSIS?

Is it even possible to process a AS2000 cube from SSIS? i tried today and got an error telling me to check and make sure the server is running... the process cube object in IS allowed me to choose the catalog in the connection but when I hit ok to get to the part of choosing what to process I got the error... If you click else where I got a invalid class string error...

I can connect to an AS2005 server just fine but not an AS 2000.... I am thinking this is not possible... I have workaround at the moment because I still have a SQL 2000 server available but that server is going away next week. We are working on upgrading to AS2005 but we are a few weeks away...

Is this possible or do I have to come up with a work around till we get upgraded?

I don't believe this is possible. AS2000 and AS2005 have completely different administrative APIs (DSO and AMO) and I believe that the SSIS tasks are based on AMO.

In order to process AS2000 objects you would need to get the DSO library onto the server running SSIS .I can't remember if there was a separate install or not. It is a COM based library, it usually gets installed with the server or with Analysis Manager. I think you can copy the dll and use regsrv32 to register it if all else fails.

Once you have DSO you could either:

1. Setup an SQL Server 2000 DTS package to do the processing and then call that package from SSIS

2. Write a vbscript to do the processing and use an execute command task to execute it.

I don't think you can call DSO from an SSIS script task, but I have not tried. In the migrations I have done I have been lucky enough to have run separate instances of SQL 2005 and migrated SSIS and SSAS together

|||

That is the answer that I was expecting to see but hoping not to see...

Thanks...