2 years ago

#48216

test-img

Robert Sacoman

SSIS send mail task is completing but not sending any files

Having an issue with this particular series. This has run perfectly fine for a number of years. Currently I am testing to see if I can get this file sent out to myself but I am coming up short. Basically this will show as completed, will continue to the next phase and move to the sent folder. However no mail is getting delivered. There is a expression and constraint tied to the success of "Check if File Exists in Root" where if this is true then it will continue on based on multiple constraints of Logical AND. Any and all help will be appreciated.

Mail Fail

Edit: Adding in visual of how the mail task is configured.

Initial set up

enter image description here

sql-server

visual-studio

ssis

visual-studio-2015

smtp

0 Answers

Your Answer

Accepted video resources