Creating Cubes in DTS

#1

Hi gurus,
I am fairly new to DTS and the world of SQL 2000.
My requirement is to be able to create cubes from DTS. I am able to process
the ones I have created manually in Analysis Services, but now I need my DTs
package to create the Cubes dynamically.

Any help would be very helpful.

Thanks in advance.
DZ

#2

You would need to use VBScript and DSO then within the DTS package.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

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

Quote:

Hi gurus,
I am fairly new to DTS and the world of SQL 2000.
My requirement is to be able to create cubes from DTS. I am able to
process
the ones I have created manually in Analysis Services, but now I need my
DTs
package to create the Cubes dynamically.

Any help would be very helpful.

Thanks in advance.
DZ

#3

Thanks Allan,
can I have some hints / examples.

Thanks
DZ

"Allan Mitchell" wrote:

Quote:

You would need to use VBScript and DSO then within the DTS package.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"dazzledare" <dazzledare (AT) discussions (DOT) microsoft.com> wrote in message
news:FB8D34C1-69D9-4911-B3E3-DEACCA6278C1 (AT) microsoft (DOT) com...
Hi gurus,
I am fairly new to DTS and the world of SQL 2000.
My requirement is to be able to create cubes from DTS. I am able to
process
the ones I have created manually in Analysis Services, but now I need my
DTs
package to create the Cubes dynamically.

Any help would be very helpful.

Thanks in advance.
DZ

#4

How about starting here

http://search.microsoft.com/search/r...a=&qn=&c=4&s=0

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

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

Quote:

Thanks Allan,
can I have some hints / examples.

Thanks
DZ

"Allan Mitchell" wrote:

You would need to use VBScript and DSO then within the DTS package.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new
stuff.
www.konesans.com - Consultancy from the people who know

"dazzledare" <dazzledare (AT) discussions (DOT) microsoft.com> wrote in message
news:FB8D34C1-69D9-4911-B3E3-DEACCA6278C1 (AT) microsoft (DOT) com...
Hi gurus,
I am fairly new to DTS and the world of SQL 2000.
My requirement is to be able to create cubes from DTS. I am able to
process
the ones I have created manually in Analysis Services, but now I need
my
DTs
package to create the Cubes dynamically.

Any help would be very helpful.

Thanks in advance.
DZ

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

Creating Cubes in DTS

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

Creating Cubes in DTS - 12-20-2004 , 12:31 AM

Re: Creating Cubes in DTS - 12-20-2004 , 12:44 AM

Re: Creating Cubes in DTS - 12-20-2004 , 02:17 AM

Re: Creating Cubes in DTS - 12-20-2004 , 12:50 PM