I get the following error when processing cubes

Step 'DTSStep_DTSOlapProcess.Task_1' failed

Step Error Source: DSO
Step Error Description:Cannot connect to the repository.

Analysis server: toronto

Error:
Unspecified error
Step Error code: 80040033
Step Error Help File:
Step Error Help Context ID:1000440

Step Execution Started: 5/23/2006 11:52:57 AM
Step Execution Completed: 5/23/2006 11:52:57 AM
Total Step Execution Time: 0.125 seconds
Progress count in Step: 0

DTS package has been scheduled as job and it runs fine when ran from
the designer. Also the olap admin group has full rights
/programfiles/microsoft analysis services/ bin directory.

any idea what might be happening here?

I would look for a general error in connection to that server's repository.
If this is ok, look into the credentials of the user that is runing that dts
and is trying to connect to that cube's repository in the olap processing
step.

To check the first option open that cube for editing as an administrator on
that server.
If you fail check the repository connection string by choosing the 'edit
repository connection string' option from the right click menu of that
server's node in management console.
You can coppy it from there and test it.

If no problem here,check the second option I've suggested.



"shahab03" wrote:

This usually happens when the login that the SQL Agent is running under
is not a domain account that is a member of the Olap Administrators
group.

If you believe that everything should be set up correctly, a good way to
troubleshoot is to logon to the server using the account that the SQL
Agent runs under and then run the package from the designer. You should
then get any errors reported through the UI.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1148412936.437430.287180 (AT) 38g2000cwa (DOT) googlegroups.com>,
shahab.nasir (AT) gmail (DOT) com says...