I've been having a problem where cubes have been processing slower when I run
them using DTS, as opposed to using the Analysis Services Manager. A Full
Process can be double or more.

Has anyone had a similar problem?

I using SQL 2000 with SP3.

Thanks.

Hello Wreck,

There is an OLAP Server Property to set the Processing Log File. Details of
cube and dimension processing are logged here.

The DTS OLAP task supports the Write TaskRecord method, and writes
detailsof the cube and dim processing to the SQL Server based log tables,
inparticular dbo.sysdtstasklog. The details in the task log table are the
sameas the processing log.

You may want to check the log to see if there is any clues.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------

Thanks Peter.

I had a look in the sysdtstasklog table, but there are no rows there. Is
there a setting I've missed?

Thanks,
Wreck.

"Peter Yang [MSFT]" wrote:

Hello Wreck,

You need to use the following method to enable the logging:

1. Open the DTS package, click package->Properties->Logging, and check "log
package execution to SQL server"

You could use the following step to check the DTS package log:

In EM, right click the DTS package->Package logs

Select the log->Open log->More Info

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------