How can i automate microsoft OLAP cube processing with dts

Build a task that does it using the "Analysis Service Processing Task" (You
will need to install AS on the server")

You can then automate this using SQL Server Agent
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"speedpassgg (AT) libero (DOT) it" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:071d01c3d645$de7b5ce0$a101280a (AT) phx (DOT) gbl...

Use the (Analysis Services) OLAP Processing Task. If SQL 7.0 then this is
avilable as a web download from the MS site. If SQL 2000, then just instal
OLAP (client tools) onto the same machine as DTS and you will get the task
in your designer. Remember DTS is a client side tool, so this means your
development workstation will need both SQL and OLAP tools to build DTS
packages like this.


--
Darren Green
http://www.sqldts.com


"speedpassgg (AT) libero (DOT) it" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:071d01c3d645$de7b5ce0$a101280a (AT) phx (DOT) gbl...

To add to Allan and Darren's posts, be aware that the order of loading your
fact and dimensions tables does matter in regards to processing your cube,
if you have problems processing your cube, you may have to process your
dimensions first. This of course can be done in the same DTS package though

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"speedpassgg (AT) libero (DOT) it" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:071d01c3d645$de7b5ce0$a101280a (AT) phx (DOT) gbl...