Membersheet Generator Interop Issues and Solutions

When running a dimension feed the member sheet generator fails with the following error:

"Problem with member sheet generator.  Please reference SQLISPackage100 Errors on the SQL Server application event log for more detail."

When inspecting the windows event viewer on the server, the following error is displayed:

There are several things that can cause this issue. The most common cause is the following:
http://bpmconnect.blogspot.com/2011/01/error-on-membersheet-generator-on-sql.html

However, if the fix from the prior link is applied, tested, and positive results are still not being yielded, this could be due to the multi-language settings on the server and in Excel.

The first step in trouble shooting any issue with the member sheet generator, is to first check the file MbrSheetGen_Log.txt which is located on the BPM Connect server in \\Program Files\Breakaway Technologies\BPM Connect\BPMC_IFramework_324\DTS\

If the log message reads "old format or invalid type library", this is an indicator there is a language conflict issue.

To solve this issue, in windows control panel on the BPM Connect server, set the region and language settings to "English"

This issue pertains to 324 pack of BPM Connect.

For reference detail on this topic, refer to following MS KB
https://support.microsoft.com/en-us/kb/320369