Attach SSIS csv file to email notification

rwheeler23
rwheeler23 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vikas GargAssociate Principal Engineer
Top Expert 2014

Commented:
Hello,

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.

Regards
Commented:
just add to your SSIS pack extra SSIS task  Send Mail Task  to send email with attachment"


it is a step by step
Sending email from SQL Server Integration Services (SSIS)
https://www.mssqltips.com/sqlservertip/1731/sending-email-from-sql-server-integration-services-ssis/
rwheeler23President

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial