Processing cubes without SQL server present.

#1

I have a machine with Analysis services on it however it does not have SQL
Server on the machine. I need some way of automating the processing of the
cubes however as SQL Server is not on the machine I cannot use DTS. Is there
any way round this?

Thanks

Justin

#2

There is the Parallel Processing utility on the SQL Server 2000 Resource
Kit.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sunil K" <sunil_kadimdiwan (AT) hotmail (DOT) com> wrote

Quote:

Here are the options.

1. You can (you may already know this) use DTS on any
other server to get the cube processed on any server. So
you do need SQLServer 2000 somewhere on your network.

2. Consider a DSO module using (say) VB 6, it is not that
hard to build a standalone utility.

Hope this helps.

Sunil.

-----Original Message-----
I have a machine with Analysis services on it however it
does not have SQL
Server on the machine. I need some way of automating the
processing of the
cubes however as SQL Server is not on the machine I
cannot use DTS. Is there
any way round this?

Thanks

Justin

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Processing cubes without SQL server present.

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Processing cubes without SQL server present. - 09-03-2003 , 08:14 AM

Re: Processing cubes without SQL server present. - 09-03-2003 , 03:58 PM