dbTalk Databases Forums  

DTS to automate OLAP cube copy / paste

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS to automate OLAP cube copy / paste in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Craig Farmer
 
Posts: n/a

Default DTS to automate OLAP cube copy / paste - 11-07-2003 , 07:31 AM






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


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTS to automate OLAP cube copy / paste - 11-09-2003 , 08:58 PM






In article <0b4901c3a533$65cee980$a301280a (AT) phx (DOT) gbl>, Craig Farmer
<craig.farmer (AT) totalise (DOT) co.uk> writes
Quote:
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

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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.