I am trying to extract data from a Cube, which is on a separate server from
the DTS package. I can run the extract successfully from within designer but
when I schedule the package then the package fails, does any one have any
ideas.

I have even added an ActiveX scipt task to the package to programaticaly open
the connection to the cube, this passes from designer but fails when the
package is scheduled.

I have logged the package and the following error is listed against the Data
Pump task.

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700