Re: Exec Package Task fails - why?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 06:37:43 -0000

There used to be this problem

http://support.microsoft.com/default.aspx?scid=kb;EN-US;246015

Can you process the cube manually? 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Soloist" <anonymous@discussions.microsoft.com> wrote in message
news:BC26405F-C27C-429E-91B4-CB6C79104D4C@microsoft.com...
> Allan,
>
> Thank you for the reply. It inspired me to look deeper into dts logs. I
found that a particular step failed which caused the whole job to report a
failure. However, the reason for the failure is still a mystery to me.
>
> The failed task is an Analysis Services Processing Task, which is set to
LOCALHOS\MyOLAPDatabase\Dimensions - Rebuild Dimension Structure. After
rebuilding dimensions for about 1 hour 30 minutes, it fails with the
following message:
>
> Step Error Source: Analysis Services Processing Task
> Step Error Description:Invalid processing option
> Step Error code: 8004021D
> Step Error Help File:
> Step Error Help Context ID:1000440
>
> Nevertheless, the dimensions seem to be rebuilt and the cubes are
available after just data refreshing processing.
>
> Any help would be highly appreciated.
>
> Soloist

Relevant Pages

  • Re: How to
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >> Error during Transformation 'DTSTransformation__1' for Row number 1. ... >> Error Help File:sqldts80.hlp>> Error Help Context ID:30632 ...
    (microsoft.public.sqlserver.dts)
  • Re: Catastrophic failure
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > designed the package for the Data Source for my dbf Connection (Source ... > only some time - say the very first time - that to again very rare. ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: Add row numbers to Text file export
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... "Marinus Willemstijn" wrote in message ... Allan you are right - there is no destination ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS object model
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... So one of my collegues suggested to go with DTS and do the validation and also mapping of columns through DTSTransformation. ... I want to create a text file connection and set the> connectionproperties of delimiter and textqualifier and then by using ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Error - Data too large for specified buffer size
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >>> www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)