sql server dts: DTS to automate OLAP cube copy / paste -- sql server dts

DTS to automate OLAP cube copy / paste

Craig Farmer
11/7/2003 5:31:06 AM

sql server dts:

Does anyone know if it is possible to automate analysis
service cubes to copy and paste from within a dts package?

If so could you point me in the direction of any reference
material.

Regards
Craig

Re: DTS to automate OLAP cube copy / paste

Darren Green
11/10/2003 2:58:55 AM

In article <0b4901c3a533$65cee980$a301280a@phx.gbl>, Craig Farmer
<craig.farmer@totalise.co.uk> writes
[quoted text, click to view]

Doubt you can do this as I suspect it is a UI option only. The OLAP
group would be a better place to ask though.

What may be a better option overall would be to use the tool in the
resource kit that allows you to script out a cube, because you can then
also migrate any other options as well.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org