This sounds like a permissions error - is there an error code?

I would check:

- Does the user account running the package have access to the mail profile

- Does the sql server engine account have access to the file

Is there a real need to do this using a SQL task? Can you not do it using a send mail task?