DTSRUN run error

• Usha-375170

  SSC-Addicted

  Points: 413

  More actions

  December 10, 2006 at 2:45 pm

  #76627

  Hi

   

  I have a package executed by SQLSERVER agent.It was executing fine over months now.It has failed over weekend with message.

  Executed as user:  DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSOlapProcess.Task_1   DTSRun OnError:  DTSStep_DTSOlapProcess.Task_1, Error = -2147221416 (80040058)      Error string:  Process Canceled      Error source:  DSO      Help file:        Help context:  1000440      Error Detail Records:      Error:  0 (0); Provider Error:  0 (0)      Error string:  Process Canceled      Error source:  DSO      Help file:        Help context:  1000440      DTSRun OnFinish:  DTSStep_DTSOlapProcess.Task_1   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.

  Thanks in advance

  Regards

  USha

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 10, 2006 at 10:08 pm

  #677144

  Your jobs was processing OLAP cube...

  Based the error process got cancelled.. so check if anyone killed sql query executing through olap cube or kill the process in Task Manager...

  Try processing it manually...

   

  MohammedU
  Microsoft SQL Server MVP