Archiving Cube via a DTS package

#1

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

#2

Hi,

Use the MSMDARCH command in a batch file and schedule that
periodically using CRON / DTS.

Regards,
Sanka

Quote:

-----Original Message-----
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
.

#3

If you don't mind my asking, why?

public @ the domain below
www.tomchester.net

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

Quote:

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

#4

If you don't mind my asking, why?

public @ the domain below
www.tomchester.net

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

Quote:

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

#5

Hi Tom,
just as monthly backup procedure.
Isn't practical doing this?, please advise.
thanks

Quote:

-----Original Message-----
If you don't mind my asking, why?

public @ the domain below
www.tomchester.net

"martino rivaplata"
anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:1021d01c3f259$98e76ae0$a601280a (AT) phx (DOT) gbl...
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

.

#6

Assuming the database is manually archived whenever structure is modified,
the data can be restored by re-processing. (Assuming continued existence in
rdbms.) Granted, making it part of a regular monthly routine makes sure
you've got an arichive.

public @ the domain below
www.tomchester.net

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

Quote:

Hi Tom,
just as monthly backup procedure.
Isn't practical doing this?, please advise.
thanks
-----Original Message-----
If you don't mind my asking, why?

public @ the domain below
www.tomchester.net

"martino rivaplata"
anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:1021d01c3f259$98e76ae0$a601280a (AT) phx (DOT) gbl...
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

.

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

Archiving Cube via a DTS package

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

Archiving Cube via a DTS package - 02-13-2004 , 11:48 AM

Archiving Cube via a DTS package - 02-13-2004 , 12:05 PM

Re: Archiving Cube via a DTS package - 02-13-2004 , 12:08 PM

Re: Archiving Cube via a DTS package - 02-13-2004 , 12:08 PM

Re: Archiving Cube via a DTS package - 02-13-2004 , 02:13 PM

Re: Archiving Cube via a DTS package - 02-13-2004 , 06:25 PM