Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS

When executing the Open function. I received the following exception:

Microsoft Office Excel cannot access the file ‘e:\report\report.xls’.

There are several possible reasons:

• The file name or path does not exist

• The file is being used by another program.

• The workbook you are trying to save has the same name as a currently open workbook.

SOLUTION:

For Windows Server x64: Create the following directory:

C:\Windows\SysWOW64\config\systemprofile\Desktop

For Windows Server x86: Create the following directory:

C:\Windows\System32\config\systemprofile\Desktop