Re: Unable to Process Cube on 64bit Server with DTS package

Tech-Archive recommends: Fix windows errors by optimizing your registry

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:

> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3BF8162E-ADA8-4B1A-81F5-1E0AB109F6D0@xxxxxxxxxxxxxxxx
> > '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
>
>
>
.

Relevant Pages

  • RE: executing SSIS remotely
    ... I found the DCOM service and set it to be used by ... p.s. I'm not sure what scheduling issues you're talking about. ... To run a package programmatically, you need to reference the library ... configure the component for remote access. ...
    (microsoft.public.sqlserver.dts)
  • unable to schedule DTS packages
    ... I am having a problem scheduling DTS packages. ... Every time I try schedule a package, it fails with an error saying the Sql ... Server does not exist or access denied. ...
    (microsoft.public.sqlserver.server)
  • Re: DTS Package run from Access on a different server: Error -2147467259; access denied
    ... I have got around the original problem using the SQL Server Agent Jobs ... Set up a job for the DTS package and remove any scheduling. ...
    (microsoft.public.sqlserver.dts)
  • Re: unable to schedule DTS packages
    ... to schedule it from EM on my computer or from EM on the server. ... Grant Merwitz wrote: ... > *I am having a problem scheduling DTS packages. ... > If I run the package immediately it works perfectly. ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to Process Cube on 64bit Server with DTS package
    ... >I can execute the DTS package on the remote server from within the package ... When we try to schedule the DTS package, ... I am unclear on how scheduling the ...
    (microsoft.public.sqlserver.olap)