dbTalk Databases Forums  

Re: SQL Server 2000 DTS to process SQL 2005 MSAS Database?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Re: SQL Server 2000 DTS to process SQL 2005 MSAS Database?

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


Discuss Re: SQL Server 2000 DTS to process SQL 2005 MSAS Database? in the microsoft.public.sqlserver.olap forum.



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

Default Re: SQL Server 2000 DTS to process SQL 2005 MSAS Database? - 12-06-2006 , 05:23 PM





you can process cubes using the ascmd utility + XML/A commands (use a simple
batch file)
DTS has no SSAS2005 tasks, so there is no other way to to this (except
creating VBScript code)

The OLAP process task of DTS can only process AS2000 cubes, not 2005.


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

Quote:
Can SQL 2000 DTS still be used for processing SQL 2005 AS database or do
we
need an SSIS package to process SQL 2005 AS database?


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top