I have a SQL Agent job which fires an SSIS package. The package contains 2 tasks which process an AS2005 database. Each cube/dimension is set to process in its own transaction. The server has 4GB of RAM.
I've been getting an unhelpful error in the eventlog stating:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured..
Can anyone point me in the right direction to try and solve this?