Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

Attach SSIS csv file to email notification

Is it possible to attach a file with the email notification of an SSIS job being completed? I have several SSIS job that run in the morning and produce csv files. For one of the jobs the client not only want email notification of completion but wants the csv file attached to the email. Is this possible? I already have the email notification set up but how do you attach the file?
Avatar of Vikas Garg
Vikas Garg
Flag of India image


You can use the attachment property of the SendMail task to attach the CSV file which is been generated from one of your intermediate steps.

With use of expression you can dynamically define the attachment path which would attach it and while sending email that will be sent.

Hope this would help you.

Avatar of EugeneZ
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rwheeler23