public void Main()
        {
            SendEmail();

            Dts.TaskResult = (int)ScriptResults.Success;
        }


        public void SendEmail()
        {
            string sSubject = Dts.Variables["EmailSubjects"].Value.ToString();
            string sBody = Dts.Variables["EmailBody"].Value.ToString();
            string sEmailUser = Dts.Variables["EmailUser"].Value.ToString();
            string sEmailSendTo = Dts.Variables["EmailSendTo"].Value.ToString();
            string sEmailServer = Dts.Variables["EmailServer"].Value.ToString();
            string sEmailPort = Dts.Variables["EmailPort"].Value.ToString();
            string sEmailPassword = Dts.Variables["EmailPassword"].Value.ToString();
            var mailMessage = new MailMessage();
            mailMessage.Sender = new MailAddress(sEmailUser);
            mailMessage.From = new MailAddress(sEmailUser);
            mailMessage.To.Add(sEmailSendTo);
            mailMessage.Subject = sSubject;
            mailMessage.Body = sBody;



            using (var smtp = new SmtpClient(sEmailServer, Int32.Parse(sEmailPort)))
            {
                smtp.EnableSsl = true;
                smtp.Credentials = new NetworkCredential(sEmailUser, sEmailPassword);
                smtp.Send(mailMessage);
            }
            Dts.TaskResult = (int)ScriptResults.Success;
        }