SSIS - Send Mail - Script Task email setting - attach Zip file - Xml content

Send Mail - SSIS

https://www.youtube.com/watch?v=1lrvm-iqFVI

Send Mail Task:->

~

General

Mail

Expression

~

Mail

SmtpConnection

From 

To 

Cc

BCcc

Subject

MessageSourceType  Direct Input

MessageSource  <--Message that you want to send ->

Priority Normal

Attachments <-Attachment of the file you want->

Note:

i.Send Mail Task -> sends text emails

But if you need to send  "HTML"  format Send Mail Task can not send.

If you want attach Zip file also it can not send.

Security:

As you are using "SmtpConnection"  , it takes your own credential.

When you move to production the "Service Account" that you use need to have permission to send email.

-----------------------------------------------------------------------------------------------------------------------------------------------

This session is using script task.

Script Task:

using System;

using System.Data;

using Microsoft.SqlServer.Dts.Runtime;

using System.windows.Forms;

using System.IO;

using System.Net;

using System.Net.Mail;

public void Main( )

{

string Sender = "entersenderemailaddress";

string Recipient = "enterrecipientemailaddress";

string SMTP="smtp.live.com";//"smtp.gmail.com";

string Body="Message that you want to send";

Attachment Attach= new Attachment("C:\\yourfilepath\\test2.zip");

MailMessage msg= new MailMessage(Sender,Recipient,"Attached Org XML Data", Body);

SmtpClient smtpClient=new SmtpClient(SMTP,25); // 25 -- SMTP Port

smtpclient.EnableSsl= true;

smtpclient.UseDefaultCredentials = false;

System.Net.NetworkCredential credentials = new NetworkCredential(Sender ,"DV6226TX"); // "DV6226TX" - current password of the email account

smtpclient.UseDefaultCredentials = false;

smtpclient.Credentials=credentials;

msg.Attachments.Add(Attach);

smtpclient.Send(msg);

Dts.TaskResult = (int) ScriptREsults.Success;

}