Hello there,

I am trying to create a DTS package, maybe a custom
processing task, that would archive an Analysis Services
cube periodically.

I think is possible to schedule a cube processing via DTS
package, but have not seen archiving the cube.

Any ideas are hightly appreciated.

Thanks

Cube archiving is done through msdarch.exe no?
You can call this through DTS but if that is all you want to do then why use
DTS?
You could equally use a batch file called by windows scheduler.


--

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


"martino rivaplata" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan, i think the batch file calling from windows
skd would to the job.