SSIS Attach Multiple Files in Send Mail Task | SSIS Send Email With Multiple Attachments

Video Title : SSIS Attach Multiple Files in Send Mail Task | SSIS Send Email With Multiple Attachments

How to Send Mails Using Send Mail Task
Link :    • SSIS Send Mail Task Example | Send Ma...  

How to Send Mails using Script Task With C# Code
Link :    • SSIS Script Task Send Emails C# | Scr...  

SSIS Attach Multiple Files in Send Mail Task | SSIS Send Email With Multiple Attachments
   • SSIS Attach Multiple Files in Send Ma...  

Subscribe to my channel :
   / @gurunathad13  

In this video we have demonstrated how to send mails with multiple file attachments using send mail task and using script task with csharp code. Here first we have dynamically generated excel files and csv files from using Flat File Destination and Excel Destination where we loaded output data from SQL Table and then on generated files we first created a pattern using script task and then we used Fileattachment variable in send mail task in an expression to send mail and same variable again used in script task to create multiple attachments using C# code. Here to test mail we used Gmail server with Gmail SMTP.

#SendMultipleFiles
#SSISAttachMultipleFiles
#SSISMultipleFilesSendMailTask
#MultipleFilesSSISMail