DTS & Analysis Services Client Installation Problem - Invalid Class String

• Phil.Nicholas

  SSCrazy

  Points: 2147

  More actions

  April 22, 2005 at 4:02 am

  #67396

  I am installing an application Ive written on end user pc's that creates a DTS job and schedules it for execution using the agent & DTSRun. The DTS job may contain a task that accesses Analysisy Services to process dimensions etc. When the job is saved it creates a new DTS Package, creates an encrypted command line for DTSRun and creates a scheduled job for some time in the future. This works fine when Enterprise Manager and Analysis Services are installed on a clients pc, however if I just install DSO, DTS & DMO along with MDAC etc from redist.exe for sp3a I get the Invalid Class String when saving the job. When Analyisis Services is installed with DMO etc. it works fine which points the finger at DSO, I have double checked the location of files and it seems to be Ok, the only lead I have on this is an msdn article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q288910 it will only be installed in one or two locations but this does seem to be a major limitation with dso! Any ideas would be appreciated...

  
  Phil Nicholas

• Phil.Nicholas

  SSCrazy

  Points: 2147

  More actions

  April 26, 2005 at 3:03 am

  #554791

  Looks like I've managed to solve the problem with the help of regmon a great free utility that tells you when & which registry entries are being checked for so by comparing the missing key with the registry on my own pc I found that a file called msmdtsp.dll and msmdtsp.rll is required just to create/open a task with dts jobs involving sql2k analysis services. The pc running the dts job would still require a full install of analysis services.

  
  Phil Nicholas