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? FYI, I don't wish to install analysis services on Web Server

You should be able to process dims and partitions from DTS.
First, make sure that you have added the SQL Agent service account to the
OLAP Administartors group (since that is who will be running the package).
If you are not running the package through SQL Agent, make sure the security
environment for how you are running it is in the OLAP Administrator's local
group.

Second, make sure that you are only running one OLAP Processing task at a
time and ensure that the "Execute on main thread" property has been set.
This is because DSO is single apartment model threaded and needs to be
called from the main thread to execute properly.

What I typically do is to write the system so that my OLAP processing is
done its own subpackage (only one OLAP Processing task per package) -- and
run the subpackage via an Execute Process task (with dtsrun on the command
line) -- nor via the Execute Package task. If you use this approach you
should have no problems getting OLAP processing working.

-------------------

From ASP.NET you might have a more complex problem as you would have to deal
with COM interop since you are using DSO.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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