dbTalk Databases Forums  

process cubes via DTS on web server

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


Discuss process cubes via DTS on web server in the microsoft.public.sqlserver.dts forum.



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

Default process cubes via DTS on web server - 05-23-2005 , 06:36 AM






Hi All,

How I can process my cubes via DTS on my web server?

My OLAP and OLTP databases is on a database server. I can run DTS package if
no process cube task in my package but the task failed when process cube was
added to the package.

ASP.NET page return error Invalid class string.

Any solution?



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

Default Re: process cubes via DTS on web server - 05-23-2005 , 10:47 AM






The error is because the OLAP Task is not installed on the web server. I
think you would be better running this package on the DB server anyway, more
secure and more efficient.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Joel Leong" <ch_leong (AT) hotmail (DOT) com> wrote

Quote:
Hi All,

How I can process my cubes via DTS on my web server?

My OLAP and OLTP databases is on a database server. I can run DTS package
if
no process cube task in my package but the task failed when process cube
was
added to the package.

ASP.NET page return error Invalid class string.

Any solution?





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.