'I have a cube on a 64bit server. I obviously can't process the cube
automatically through a scheduled job or DTS package since they can't be run
on the 64bit version of SQL 2000. I have a DTS package utilizing the
'Analysis Services Processing Task' on a 32 bit server trying to process the
cube on the 64bit box. The DTS package will process the cube when executed
from within the package, however, when scheduling the package as a job it
fails. This is the error message. Any help is appreciated.
Executed as user: evercom\svcsql. DTSRun: Loading... Error:
-2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid
class string Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help context: 713. Process
Exit Code 1. The step failed.
--
Lance McCaskey

Seems like a security issue...might be a firewall problem. Or even
credentials.

It's not a 64 / 32 bit issue. We do the exact same thing you're attempting
to do with success. I have run into the same problem you have and it's
always been due to firewall problems.

Can you run the package manually on that server? Or are you running the
package remotely with success?




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

I can execute the DTS package on the remote server from within the package
without a problem. When we try to schedule the DTS package, the scheduled
job has the issues outlined below. I am unclear on how scheduling the
package creates the problem. I found a Microsoft knowledge based article
that had me add permissions via DCOMcnfg.exe. This proved fruitless. It
almost looks like a VB error that is being encountered.
Thanks,
--
Lance McCaskey


"Jesse O" wrote:

1) Have you configured the SQL Agent service account to be a domain account
in common between the 32-bit server and the 64-bit server?

Then 2) Add that domain account to the OLAP Administrators group on the
64-bit server.

--
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.


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

Yes on both counts.
--
Lance McCaskey


"Dave Wickert [MSFT]" wrote:

Ok. Let's see if this is a SQL Agent issues or a DSO issue.
Can you try three things:
1) Login into the 32-bit system using the domain account that SQL Agent is
configured to use. Can you execute the package interactively using dtsrun?
2) In the same login session as #1, Can you run Analysis Manager to remotely
process the partition or dimension?
2) Can you write a package which executes a TSQL task (using integrated
security) that does a SELECT * FROM OLAP OBJECTS in the OLAP repostiory
database? Does it run interactvely (using dtsrun)? Can it run scheduled
interactively?

My guess is that we have a mis-configuration here somewhere. Let's see if we
can identify which subsystem is the real problems.

Hope that helps.
--
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.


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

Do you have to install OLAP on both the servers for this to work? Our 32 bit
server acts as a job broker for the 64bit server and really doesn't do
anything else.
Thanks,
--
Lance McCaskey


"Dave Wickert [MSFT]" wrote:

1) Failed. This is the result:
Error Cod:0
Error Source= Microsoft VBScript runtime error
Error Description: ActiveX component can't create object: 'DSO.Server'
Error on Line 14

2a) Can't do this because Analysis Services is not loaded on this Server

2b) This was successful

Any ideas?
Thanks,
Lance
--
Lance McCaskey


"Dave Wickert [MSFT]" wrote:

Your 32-bit machine needs to have AS installed on it. (#2a). This is also
the reason why #1 would be giving you this error.

Although I am confused as to how you were able to run the package under your
interactive account and have it work w/o having AS installed.
--
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.


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

Please see microsoft KB Q288910 PRB: "Invalid Class String" Error When
Opening DTS Package. It is related.


*** Sent via Developersdex http://www.developersdex.com ***