Configure SMTP server to connect to GMAIL in local system to use send email task

hi team,

i doing ssis package development in local machine. have requirement send email output.

i developing in local machine. possible configure smtp configuration in local system receive email in gmail?

if yes, steps followed.

br,

shamsuddeen

hi shamsudden,

gmail not implement/support smtp communications, cannot that.

but can  check commercial cozyroc send mail task, part of ssis+ library. support gmail smtp.

or can use ssis script task , configure email on there looks this

 public static void main(string[] args)
            {
                mailmessage mail = new mailmessage();
                //set addresses
                mail.from = new mailaddress("chandran.nr@gmail.com");
                mail.to.add("chandran.nr@gmail.com");
                //set content
                mail.subject = "this email";
                mail.body = "this body content of email.";
                //send message
                smtpclient smtp = new smtpclient("smtp.gmail.com",465);
                smtp.deliverymethod = smtpdeliverymethod.network;
                //to authenticate set username , password properites on smtpclient
                smtp.credentials = new networkcredential("chandran.nr@gmail.com", "xxx12345");//no need mention here?
                smtp.send(mail);
            }

---

please dont forget mark answer , helpful post. helps others find relevant posts same question. milan das

SQL Server  >  SQL Server Integration Services