Can u verify the number of rows or columns is not exceeding the limit of excel.

Only on success add the send email task

Try by keeping the file on C: not something like a desktop

Hey try to create a login in sql and run the package under it.Also create a proxy account if you are running it as a job