dbTalk Databases Forums  

OLAP Dts Package Fails HELP!!!

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


Discuss OLAP Dts Package Fails HELP!!! in the microsoft.public.sqlserver.olap forum.



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

Default OLAP Dts Package Fails HELP!!! - 04-09-2004 , 07:33 PM






I have some olap dts packages that were working fine for
several months. Now all of a sudden i get an error
message:

DTSStep_DTSOlapProcess.Task_4, Error = -2147221397
(8004006B) Error string: Invalid aspect(s)
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help
context: 700 Error Detail Records: Error: -
2147221397 (8004006B); Provider Error: 0 (0) Error
string: Invalid aspect(s) Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 700...
Process Exit Code 1. The step failed.

I've searched the net for this error message and came up
with nothing. Anyone have any similar problems? Nothing
has changed with the server, it just stopped all of a
sudden. It's a windows 2000 server, with sp3 for sql
server and analysis services. Thanks in advance for any
help!



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: OLAP Dts Package Fails HELP!!! - 04-12-2004 , 08:55 AM






Many times, the errors being reported up through the DTS OLAP Process task
can be misleading. The error codes can get corrupted as it is reported up
the call stack. The best way to debug the problem is to turn on the
system-wide processing log. See section titled "Processing Log File" in the
Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"someone" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have some olap dts packages that were working fine for
several months. Now all of a sudden i get an error
message:

DTSStep_DTSOlapProcess.Task_4, Error = -2147221397
(8004006B) Error string: Invalid aspect(s)
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help
context: 700 Error Detail Records: Error: -
2147221397 (8004006B); Provider Error: 0 (0) Error
string: Invalid aspect(s) Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 700...
Process Exit Code 1. The step failed.

I've searched the net for this error message and came up
with nothing. Anyone have any similar problems? Nothing
has changed with the server, it just stopped all of a
sudden. It's a windows 2000 server, with sp3 for sql
server and analysis services. Thanks in advance for any
help!





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.