MSI, verify that this is a valid Windows Installer package

The Message:
"This Installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package."
I tried to install a few software which were bundled into a MSI (Microsoft Installer) Package,
and kept getting the message.

My system is running on Windows XP SP2, Searched the web, installed hot fix for SP2 or MSI I dont remember nor did it matter, Even got the latest version of MSI installed, but to no avail.

Finally figured out my self, the XP was logged into the username called "D'Souza" and the single quote in "D'Souza" was the issue, and windows couldn't locate the package or the extracted package which is stores in that users profile TEMP folders

The work around which i did, since i needed a quick fix solution, i created anothe profile with out the single quote or special characters in betweenand installed the package by switching the user.

If any one aware how to get this done on the current profile or edit the current profile settings do let me know.

I hope this helps, for people like me who are struggling with this MSI issue.