Despite the long name this issue is pretty simple. There are certain situations that when activating an Office 2010 layer you the following error message:
"BCSSync.exe - Unable to Locate Component
This application has failed to start because mscoree.dll was not found. Re-installing the application may fix the problem."
What's going on is a service of Office 2010 named Business Connectivity Service is looking for mscoree.dll which is one of the core .NET files, but doesn't actually need mscoree.dll to run. The reason for this error is that Office 2010 was captured into SWV on a system with .NET installed and them migrated over to a machine without .Net. This is an example of an issue you get with SWV where something expects certain files to be on the system even if the application doesn't need them and is a main reason why we tell customers to always capture on the oldest OS you want to support and in the environment you want to support. A common way to hit similar issues with various applications is to capture on XP and move the application to Windows 2000 or from Windows 7 to XP--Each of those OSes have different core files that aren't on previous versions.
With regards to this particular error there are two simple ways to resolve this:
1) Install the same .NET frameworks on the client that the packaging machine has
2) Re-capture Office 2010 on a machine without .Net.