Hi all

Is it possible to schedule olap tasks management, like this :

create an archive ( cab file )
restore a cab file .....
In case it's possible do we have to use specific tools like DTS.

Thanks for reply

msmdarch is a command-line utility (see books on-line).
As such, it can easily be scripted using SQL Agent to automate/schedule.
When you create a step in a SQL Agent job, one of the options is a
command-line utility.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"patrick" <micheaup (AT) yahoo (DOT) fr> wrote