InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:57:36 GMT20http://www.sqlservercentral.com/Forums/Topic1353076-148-1.aspxHi Hariplease provide more detailed specs on the question. For this question, its not that the quesion is not clear.....but still people would like to get more detailed question with all the gaps filled in.So now with your answer :Set up a variable count_files_deleted in your SSISFill this variable up with the number of files deleted. (lets say from a script component or maybe a RowCount transformation etc.)In your SenMail task, use an expression utilizing this variable count_files_deleted to create your MessageSource property for the SendMail task.Thu, 13 Sep 2012 13:44:11 GMTn79799http://www.sqlservercentral.com/Forums/Topic1353076-148-1.aspx[quote][b]harri.reddy (8/31/2012)[/b][hr]hi i need to give mail ,that if number of file deleted is 5. the message should be 5 file deleted. i am using send email task to email.but how to count 5 in send email task[/quote]???[url=http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx]http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx[/url]Fri, 31 Aug 2012 14:16:45 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1353076-148-1.aspxhi i need to give mail ,that if number of file deleted is 5. the message should be 5 file deleted. i am using send email task to email.but how to count 5 in send email taskFri, 31 Aug 2012 13:49:34 GMTharri.reddy