Problem

The following error appears after executing a scheduled SQL Agent job that runs an SSIS package:

 Code: 0xC0014023     Source: Foreach Loop Container      Description: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.  End Error  DTExec: The package execution returned DTSER_FAILURE (1)

 

Solution

In this situation, the SSIS package is used to automatically back up all the database cubes from an SSAS instance running on the same machine. The service account used to start the SQL Agent doesn?t have rights in SSAS.

 

...

 

To solve this you must give admin rights on SSAS to the service account. 

Also, please make sure that the database cube set in ?Initial catalog? drop down box, when the SSIS package was originally designed, still exists on your SSAS instance. 

 

 


No feedback yet