Hi,

I have read through a few of the different threads to try and solve my
problem, but as yet no luck. I'm hoping someone can shine a guiding
light...

I have designed a vb.net app that, as part of it's functionality,
executes a DTS package that creates tables in a sql 2000 db and then
processes an analysis services cube. The process works fine and dandy
on my machine (which has both sql and AS installed). However i am
experiencing difficulties when deploying the application to users who
have neither sql nor AS installed (and have no need to install them).
I initially had problems simply executing the DTS package, however i
have overcome this by installing all of the relevant DLL's listed in
the redist.txt list.

So my initial problem was corrected and the user can now create tables
in sql. However the 'processing analysis services cube' task is
proving a little harder to fix. I originally received an "invalid
class string" error, which disappeared once i registered the
msmdtsp.dll file. I am now receiving the "ActiveX component can't
creat object" error.

I guess my question has 2 parts:

(1) Can the user process a cube through an application without
requiring analysis services to be installed on their machine?
(2) If yes to the above question - what additional dll's or components
do i need to install to get this working?

ps ... i am simply calling a loadfromsqlserver() command to execute the
dts package.

Many Thanks,
Ryan.