I physically signed on to the server as Admin and executed the package in BDIS and it worked fine and wrote the spreadsheet to the file as it is suppose to do..

I then opened the SQL Server Management Studio and connected to Integration Services and executed the package from there, and again it worked fine .

I then created a new SQL Agent job being signed on as Admin and when I ran the job which executed the package, it failed with the same error message as before.