24.SSIS TUTORIAL - HOW TO USE SCRIPT TASK FOR EMAIL WITH SCRIPT CODE - HINDI
EXPLAINED ABOUT HOE TO USE SCRIPT TASK FOR MAILING FROM ONE EMAIL ID TO ANOTHER EMAIL ID WITH THE ATTACHMENT.
GIVING THE CODE TO WRITE IN THE EDIT SCRIPT IN HINDI .
Public void Main()
{
String userName = "[email protected]";
String password = "1123ssistestscript";
SmtpClient client = new SmtpClient();
client.Host = "smtp.gmail.com";
client.Port = 587;
client.EnableSsl = true;
NetworkCredential mycredentials = new NetworkCredential(userName, password);
client.Credentials = mycredentials;
MailAddress FromAddress = new MailAddress("[email protected]", "SSIS");
MailMessage message = new MailMessage();
message.From = FromAddress;
message.To.Add("[email protected]");
message.Subject = "Sample ssis script example";
message.IsBodyHtml = true;
message.Body = "This is the script mail example with the attachments ";
message.Attachments.Add(new Attachment("C:\\Users\\vinod\\OneDrive\\Desktop\\outputfolder\\Student_20210925.txt"));
client.Send(message);
Dts.TaskResult = (int)ScriptResults.Success;
}