dbTalk Databases Forums  

Error executing cube via DTS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error executing cube via DTS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.