SSIS Mail send task and script task

Question

Dear Sir, Please look into the data and suggest... I need your help on my on going project the scenario is as follows" Suppose we have four HOD and each hod has few employee under their reporting each employee gives print out every day. we need to send sum of print for employee under HOD1 and send email with CSV file(contain Printout detail) attachment to HOD1 through SSIS package, similarly for second HOD2, HOD3 and HOD4 respectively. " Please help me to configure ssis package. my table structure is like below.....

HOD_ID HOD_Name Emp_Name dateofprint printout 1 R_Ranga Ram 2023-11-02 21 2 R_Sanga shyam 2023-11-02 23 3 R_Kanga Knhu 2023-11-02 12 4 R_Vanga Vishal 2023-11-02 10

--
Regard,

Shyamnarayan Chauhan

Answer 1

Hi @shyamnarayan chauhan

Not clear about the issue, do you mean you want to send different attachment to different people?

If yes, you may need to add the e-mail address and the attachment path in the table.

And then you refer to below two links for details.

https://stackoverflow.com/questions/6439663/how-to-send-the-records-from-a-table-in-an-e-mail-body-using-ssis-package

https://www.wiseowl.co.uk/blog/s437/ssis-email.htm

You may also use sp_send_dbmail (Transact-SQL) to do that.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Please look into the data

There is no "data", only a screenshot, where nobody can work on.

my table structure is like below.....

There is nothing below.

Please post table design as DDL, some sample data as DML statement and the expected result.