SSIS Run Excel Macro Error
Solution:

https://stackoverflow.com/questions/881132/retrieving-the-com-class-factory-for-component-failed


In DCOMCNFG, right click on the My Computer and select properties.
Choose the COM Securities tab
In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for \Users.
In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for \Users