dbTalk Databases Forums  

Re: Invalid class string error when opening DTS package

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


Discuss Re: Invalid class string error when opening DTS package in the microsoft.public.sqlserver.dts forum.



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

Default Re: Invalid class string error when opening DTS package - 07-22-2004 , 08:42 AM






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




Reply With Quote
  #2  
Old   
Annick
 
Posts: n/a

Default Re: Invalid class string error when opening DTS package - 07-23-2004 , 02:38 AM






Hi, thanks for the reaction,

Do I need to install the complete Analysis Services Manager or just part of it. How do I do this, I can only select a complete install with our setup CD. Does it have to be installed on the SQL-cluster or the Windows-cluster.

Thanks in advance,
Annick van den Broek


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.