It is nothing to do with clustering,. Invalid class string means it cannot
find a component it requires, in this case the OLAP Processing task sounds
favourite.
The SQL server, clsutered or not, does not have the OLAP task, so you will
need to the OLAP client tools tio get the task to be available. I assume you
will have to do this on all cluster nodes, since it is a not a cluster aware
product/install.
--
Darren Green
http://www.sqldts.com
"carel (AT) sfbgroep (DOT) nl" <carel (AT) sfbgroep (DOT) nl (AT) discussions (DOT) microsoft.com> wrote in
message news:492925F0-7B2C-443E-B8F3-5957F10AA7D1 (AT) microsoft (DOT) com...
Quote:
Hi there,
We are working with:
SERVER 1
--> Clustered Microsoft SQL Server 2000 SP3a
(Node A = Exchange; Node B = SQLserver)
SERVER 2
--> Non-clustered Analysis Services SP3
I have a problem with executing some DTS-packages on our clustered
SQLserver (Error string: Invalid class string). However the packages do
|
fine when I execute them directly from my machine. I found that this only
occurs with packages containing Analysis Services Tasks. Microsoft Knowledge
Base Article - 288910, describes a possible explanation. However I don't
fully understand the workaround. As far as I know the Analysis Services is
not cluster aware. Do I have to install the complete Analysis Services or
only the required components? And if so, how do I do this? Could you please
give me step by step instructions, as to what to do? I would be ever so
grateful!!
Quote:
Thanks in advance,
Annick van den Broek |