CODEWITHSUNDEEP
ssis
Umberto
Umberto

Reputation: 2060

SSIS 2012 Send Mail Task with an attachment

My SSIS package writes a log file during the execution. In the end it calls another package that sends that log file via email.
I'm not able to send it (the email without the attachment works fine) and I always get this error:

[Send Mail Task] Error: Either the file "F:\ etc..." does not exist or you do not have permissions to access the file.

I've already tried to:
- set DelayValidation property to True for the Send Mail Task;
- close the filestream of the log file before sending the email.
but nothing changes...

Upvotes: 1

Views: 4817

Answers (1)

Umberto
Umberto

Reputation: 2060

I added the file extension to the file path and now it works! I also left DelayValidation property set to True for the Send Mail Task.
I didn't think of it because I saw that Windows opened the file, even if without extension.

Upvotes: 1

Related Questions