FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails (295442)

SYMPTOMS

When attempting to process an OLAP 7.0 cube, partition, or dimension from the OLAP processing task in Data Transformation Services (DTS) on SQL Server 2000, the OLAP processing task may fail. If the package is run interactively in the DTS Designer, when you double-click the failed task in the processing dialog box, the following error message is received:

Object doesn't support this action.

The DTS package log shows the following error:

Step Error Source: DSO
Step Error Description:Object doesn't support this action
Step Error code: 800A01BD
Step Error Help File:
Step Error Help Context ID:1000445

If the package is executed from the SQL Server 2000 Enterprise Manager, the following error message is seen and the Enterprise Manager shuts down.

---------------------------
mmc.exe - Application Error
---------------------------
The instruction at "0x415ceda8" referenced memory at "0xa8c9480c". The memory could not be "written".

CAUSE

The DTS task attempts to use the ProcessingLogFileName property of the OLAP/Analysis Server for DTS logging. Because this property was added in Analysis Services and does not exist in OLAP 7.0, the OLAP server returns an error, causing the DTS OLAP task to fail.

RESOLUTION

To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.