Member_2_7969381
asked on
SSIS : Send Mail Task Error: File doesn't exist or you don't have permission.
I was trying to attach LOG files in send mail task. I have multiple log files to attach. When I use direct path to attach file, It works but when I use variable, it's giving me error. I am using following expression with user variable. I also set Delay Validation = True.
@Log_File_Attachment: "\\\\ServerName\\Drive$\\F older 1\\Folder 2\\Folder 3\\*.log"
Please correct me where I am mistaking.
@Log_File_Attachment: "\\\\ServerName\\Drive$\\F
Please correct me where I am mistaking.
Click on the expressions tab (on the left of the Send Mail task editor) and expand/click on the ellipsis on the Expressions box on the right. Select the "FileAttachments" property and type in @[User::filename] into the Expression box.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you resolved the problem, you can close out the thread and select your own post as the solution.
ASKER
Thanks to all
@Log_File_Attachment: "\\\\ServerName\\Drive$\\F