After processing each file then send notification with the following format Subject : {FileName} has been processed. Body : {FileName} has been successfully processed and transfered {N} records. (Here {N} is number of records transferred from the particular file to table) Note : Use configurations to get FROM, TO and CC list

http://support.microsoft.com/kb/906547 Just make sure to cast your {N} to a wide character string.Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers

the built-in send mail task in SSIS is not very good in term of troubleshooting and debugging, you can use script task to send mail as you want, and you can use package variables to make that dynamic. this is an example: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66415/http://www.rad.pasfu.com

you have to define the user variable which contains the filename etc information which you can used in the send mail task expression as mentioned in the following article: http://bisherryli.wordpress.com/2010/11/04/ssis-using-system-variables-in-send-mail-task/ thanks, Zaim Raza.

Its very simple srinivas.. Anyway you are having file name and recound count in variables.. Go to send Mail Task expression tab... Write expressions over there.. Subject: @filename+"has been processed." MessageSource: @fileName+" has been successfully processed and transfered+@reccount+ "records. (Here +@recount+ is number of records transferred from the particular file to table)", check the below screenshot.

Its very simple srinivas.. Anyway you are having file name and recound count in variables.. Go to send Mail Task expression tab... Write expressions over there.. Subject: @filename+"has been processed." MessageSource: @fileName+" has been successfully processed and transfered+@reccount+ "records. (Here +@recount+ is number of records transferred from the particular file to table)", check the below screenshot.

Hii Thanks for your valuable information,but i want to know which value field of @reccount variable

Hi,thanks ! After processing each file then send notification with the following format Subject : {FileName} has been processed. Body : {FileName} has been successfully processed and transfered {N} records. (Here {N} is number of records transferred from the particular file to table) how can i achieve by using script task

Hi SrinivasMullamuri, The built in Send Email task from the SSIS package does not have the option of indicating a user name and password, it will only authenticate using Windows Authentication, if you have an email provider that does not use that authentication model You can develop your Sending Email using C# language in Script Task, please refer to detail steps in the following link, http://www.codeproject.com/Articles/85172/Send-Email-from-SSIS-with-option-to-indicate-Email Please feel free to ask if you have any question. Thanks, Eileen