MakeDim Task - The script returned a failure result

When running a dimension feed, the following SSIS error is logged in the application event viewer:

Event Name: OnError
Message: The script returned a failure result.
Operator: BPCSysadmin
Source Name: MakeDim Task
Source ID: {EC6BD535-F670-4F1C-A50F-6A25EA831664}
Execution ID: {FD6586C5-90EB-4F2E-AC1B-FE4F96B76849}
Start Time: 7/23/2012 5:43:50 PM
End Time: 7/23/2012 5:43:50 PM
Data Code: 8

This error can be caused sometimes due to incorrect setting on the feeds surface area. 

To solve in Config Builder:
1) Select your feed in question

2) Goto: Surface Area -> Staging Environment -> Advanced
3) Turn the ETL Distributed switch to "Y"
4) Set the server to the BPC Application server
5) Click Save.

See also:
http://bpmconnect.blogspot.com/2012/08/bpmc-makedim-error.html