"Could not find file C:\Documents and Settings\username\Local Settings\Temp\xxxxxxx.dll"

Getting below error message when we try to create a Business Intelligence Project[SSIS]

"Could not find file C:\Documents and Settings\username\Local Settings\Temp\xxxxxxx.dll"

Issue seems to be an corruption with Dot Net framework dll.

SQL 2005 uses dotnet framework 2.0
SQL 2008 uses dotnet framework 3.5

Uninstalling and reinstalling the framework Should resolve the issue.

Attempting to install is MS07-009, which corresponds to KB article 927779 and its failing with error.

Before making any changes to registry key do a backup of it.

1.Remove the MDAC Exception component keys from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents.

2. Re-run the MDAC 2.81 installer (MDAC_TYP.EXE). When the installer runs you should see a few windows coming up showing it copying files.
http://www.microsoft.com/downloads/details.aspx?FamilyID=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en [mdac 2.8 sp1 download]

3. Apply the update again and if need be reboot the machine.