InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:17:40 GMT20http://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspx[quote][b]abhas (12/5/2012)[/b][hr]Hi rhythm,I am doing below steps.1) Execute sql task - here I am fetching studid,studname,deptname,HodName,HodMail.2) I am using foreach loop3) In foreach loop I am using script task and sendmail taskIn script task I am fetching mailid's and writting body of message. But what happens in this case suppose there are 3 students belongs to physics dept then 3 separate mails are going to HOD.I want to send single mail for three students as;Dear Sir,student1,student2,student3 are absent today.Please take required action.ThanksAbaso Jadhav[/quote]Thats what I doubted.Use send mail task outside for each loop.I hope you are using package level variable for stroing email ids.Thu, 06 Dec 2012 04:40:00 GMTrhythm.varshneyhttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspxHi rhythm,I am doing below steps.1) Execute sql task - here I am fetching studid,studname,deptname,HodName,HodMail.2) I am using foreach loop3) In foreach loop I am using script task and sendmail taskIn script task I am fetching mailid's and writting body of message. But what happens in this case suppose there are 3 students belongs to physics dept then 3 separate mails are going to HOD.I want to send single mail for three students as;Dear Sir,student1,student2,student3 are absent today.Please take required action.ThanksAbaso JadhavWed, 05 Dec 2012 22:28:06 GMTabhashttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspx[quote][b]abhas (12/5/2012)[/b][hr]Hi rhythmI am doing the same but emails are going repeatedly.Example if there are 5 students then 5 different mails are going.ThanksAbhas.[/quote]Probably you have include your mail task in loop container or so.Please check and if not then attach screenshots or explain your package ?Wed, 05 Dec 2012 01:48:12 GMTrhythm.varshneyhttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspxHi rhythmI am doing the same but emails are going repeatedly.Example if there are 5 students then 5 different mails are going.ThanksAbhas.Wed, 05 Dec 2012 00:46:40 GMTabhashttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspx[quote][b]abhas (12/4/2012)[/b][hr]Hi Jeet,I want to use this by using SSIS.ThanksAbaso jadhav[/quote]Store the names of student in string variable using Execute Sql Task and then use send mail task to send mail.Tue, 04 Dec 2012 23:29:49 GMTrhythm.varshneyhttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspxHi Jeet,I want to use this by using SSIS.ThanksAbaso jadhavTue, 04 Dec 2012 22:56:16 GMTabhashttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspxyou can use the procedure to first have the list of studentsabsent in a particular department and then use the proceduresp_send_dbmail to send the list of absentees in the mail.Tue, 04 Dec 2012 22:43:47 GMTjeetsingh.cshttp://www.sqlservercentral.com/Forums/Topic1392782-364-1.aspxHi,Please help on below scenario to send mail.I am having a table which contains student attendance. If student is absent then the mail should automatically goes to HOD. But issue is that i don't want to send mail one for each student. Suppose there is maths department and 7 students are absent then all 7 students name i want to send to HOD by the mail. I am able to send but 7 mails are going. Can you please help? its urgent.ThanksAbhasTue, 04 Dec 2012 21:53:18 GMTabhas