How to Send Mail in SSIS | send mail task in ssis | ssis tutorial Part 48
Автор: SS UNITECH
Загружено: 2019-05-18
Просмотров: 11128
Описание:
string sender="sender mail id";
string recipant = "receiver mail id";
string smtp="smtp.gmail.com";
string body="Hi Team,Please find attached file. Thanks-SS UNITECH";
Attachment attach =new Attachment("F:\\Youtube\\SSIS\\Part 49 (How to Send mail using script task in SSIS)\\Script.txt");
//Attachment attach1 = new Attachment("F:\\Youtube\\SSIS\\Part 49 (How to Send mail using script task in SSIS)\\Script2.txt");
MailMessage msg = new MailMessage(sender, recipant, "Attachedfile", body);
SmtpClient smtpclient=new SmtpClient(smtp,587);
smtpclient.EnableSsl=true;
smtpclient.UseDefaultCredentials=false;
NetworkCredential credentials=new NetworkCredential(sender,"Password");
smtpclient.Credentials=credentials;
msg.Attachments.Add(attach);
//msg.Attachments.Add(attach1);
smtpclient.Send(msg);
Find Us On YouTube- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For Quiz-
• sql server : Interview Quiz | sql server i...
Find Us On FaceBook-
/ ss-unitech-187705388674384
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
