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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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) 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@xxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:72032522-35FD-4253-A47E-6D52C458F652@xxxxxxxxxxxxxxxx
> >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

  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)
  • is yum working? unable to update a system
    ... # yum update ... Server: Dag RPM Repository for Fedora Core ... .Package mplayer-mencoder needs libxvidcore.so.2, this is not ...
    (Fedora)