Guys,

I had received below error in Analysis Services Process task.

Internal error: The operation terminated unsuccessfully.

Initially I did not understand where was the problem since it runs successfully when we run this package through SQL Server Agent Job which does run under DBA group account. But one of our DBA execute this package under his authentication and this error occured. So I asked DBA to create a SQL Server Agent Job and execute this package from newly created job and it worked.

For more information on this issue. Please refer to below URL.

http://social.technet.microsoft.com/wiki/contents/articles/3174.how-to-process-and-deploy-an-ssas-cube.aspx

Hope it would help you.

Regards,

Bhushan