Processing Cubes via a SQL Server 2000 DTS

Hi,

I have a DTS which processes a set of AS 2000 cubes via a set of AS Processing Tasks.

I want to know how I can accurately trap and report errors once a cube fails to process?

Thanks in advance

Jon Derbyshire

The logging of processing errors in DTS ( SQL Server 2000 ) is bit limited.

You should try and look at migrating your application to SQL Server 2005 instead. I know it is bit a far fetched suggestion to migrate your whole solution to SQL Server 2005 just because of a single problem with accurately tracking processing errors. But the problem is: your will find increasingly harder to implement any new functionality with old version of the product. You will find it harder to find answers to your questions in the community that has moved to new ( different) technologies. At some point you should look at developing new solution using SQL Server 2005.

Hope that helps.

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