SSIS Attach Multiple Files in Send Mail Task | SSIS Send Email With Multiple Attachments
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2024
- 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 Ex...
How to Send Mails using Script Task With C# Code
Link : • SSIS Script Task Send ...
SSIS Attach Multiple Files in Send Mail Task | SSIS Send Email With Multiple Attachments
• SSIS Attach Multiple F...
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
Thanks so much. Very helpful! I need to review your send email videos. I am planning on looping through a series of subdirectories and creating an To address based upon the name of the directory, and sending any and all files in the subdirectory via attachment. You gave me a great start. Thanks so much!
Hi Sir, can you guide how to send an email to dynamically recipient using send mail task as "ToLine" is not accepting variables
Please use expression using variables or use script task component
Hi Sir Can you please create a video in which we can generate diff files for diff client and send those files to that particular client only using script task.
Is it possible sir
How to send multiple files to multiple clients using ssis package can you please create this video
Can you add one more like if the file is empty then not send that file only send the file which has data in it?
Yes we can do by checking file size or checking column data 👍