I have a DTS package in SQL Server 2000 which brings together data from
different sources, including from an Analysis Services cube, and compares it.

Usually this runs perfectly, but sometimes I get an unexpected internal
error from the Data Pump task which queries the cube - no other information,
just the error.



This is usually when I have run the package once (manually from Enterprise
Manager), then changed a global variable and run it again.



The cube it is querying is a virtual cube and the measures are calculated
cells (NOT calculated members).



We are on SP4 of AS so should be up to date.



Does anyone have any ideas?



Thank you