dbTalk Databases Forums  

Cloning Partitions using DSO in SQL Server 2005

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


Discuss Cloning Partitions using DSO in SQL Server 2005 in the microsoft.public.sqlserver.olap forum.



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

Default Cloning Partitions using DSO in SQL Server 2005 - 11-01-2005 , 04:19 AM






I am trying to clone a partition using DSO in MSIS Script Task and I get an
error. Does anyone have a small example of using the clone function and it
actually working.

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Cloning Partitions using DSO in SQL Server 2005 - 11-01-2005 , 11:48 AM






You should be using AMO for that; not DSO.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"RB" <RB (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to clone a partition using DSO in MSIS Script Task and I get an
error. Does anyone have a small example of using the clone function and it
actually working.



Reply With Quote
  #3  
Old   
RB
 
Posts: n/a

Default Re: Cloning Partitions using AMO in SQL Server 2005 - 11-01-2005 , 01:45 PM



Sorry, I did mean AMO, i was looking at other posts and had DSO in mind.

"Dave Wickert [MSFT]" wrote:

Quote:
You should be using AMO for that; not DSO.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"RB" <RB (AT) discussions (DOT) microsoft.com> wrote in message
news:169021D4-4A5D-4043-B838-1727B25EBA01 (AT) microsoft (DOT) com...
I am trying to clone a partition using DSO in MSIS Script Task and I get an
error. Does anyone have a small example of using the clone function and it
actually working.




Reply With Quote
  #4  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Cloning Partitions using AMO in SQL Server 2005 - 11-01-2005 , 04:39 PM



The best source for AMO samples is the AMOAdventureWorks and the
DisplayUniqueNames samples in the SQL2K5 Samples.msi.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"RB" <RB (AT) discussions (DOT) microsoft.com> wrote

Quote:
Sorry, I did mean AMO, i was looking at other posts and had DSO in mind.

"Dave Wickert [MSFT]" wrote:

You should be using AMO for that; not DSO.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.


"RB" <RB (AT) discussions (DOT) microsoft.com> wrote in message
news:169021D4-4A5D-4043-B838-1727B25EBA01 (AT) microsoft (DOT) com...
I am trying to clone a partition using DSO in MSIS Script Task and I get
an
error. Does anyone have a small example of using the clone function and
it
actually working.






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.