Hi, I am sending Emails on "OnError" even of my SSIS packages. The downside of this approach is, it sends out loads of emails and almost chocks my inbox. I am looking for a better solution. Please suggest me some way of sending one Comprehensive Email once execuation is finished. SamSaadat

How about moving/Adding Send E-mai task onto Control flow and configure it on failure using precedence constraints? Rajkumar Yelugu

How do you design it?

check this link it has your answerSincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

check this link it has your answerSincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).