<div>
Hello,<br />
<br />
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.<br />
<br />
With use of expression you can dynamically define the attachment path which would attach it and while sending email that will be sent.<br />
<br />
Hope this would help you.<br />
<br />
Regards
</div>


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

President

rwheeler23

<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Attach SSIS csv file to email notification

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.