Error executing cube via DTS -
10-03-2006
, 12:15 AM
Hi,
I get the following error when trying to execute a cube via a dts
package when i run it from a remote server that has the sql server tools
installed, but no server, and analysis manager installed. Does anyone know
what I have done wrong?
I am running SQL Server 2000 Sp3a on the database server and MS Server 2000
on the database server and MS Server 2003 on the remote server.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\PrdInform>dtsrun /s adlsqlrpt /n ml_test /e
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828218 (800A0046)
Error string: The remote server has been paused or is in the process of
bein
g started.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
Error Detail Records:
Error: -2146828218 (800A0046); Provider Error: 0 (0)
Error string: The remote server has been paused or is in the process of
bein
g started.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Permission denied
Error source: DTSOlapProcess
Help file:
Help context: 1000070
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun: Package execution complete. |