Use Text file for Email Attachment in SSIS

In this scenario, Email will be send to the relevant Manger regarding their vacant position and the Action and KPIs which relevant to that position. From this email, manager can immediately assign the work to someone else.

SEND EMAIL FOR VACANT POSITION for each loop will iterate for each and every position.

Create the variable for File path and for the Containing relevant information which need to send as attachment.

Assign the variables in the script task and write the code for writing the information.

(VB.Net code)

Make sure False as 2nd parameter for StreamWrite to overwrite the file.

And set the expression as below in the Send Email task.

Cheers!