I cannot run this program. it shows timeout and failure in sending mails. handshake fail due to unexpected packet format .
what to add or edit now?
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Net.Mail; // Added
using System.Net.Mail;
namespace ST_df6618207373422d961b80ca8b6a56e2
{
[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{
public void Main()
{
String SendMailFrom = Dts.Variables["EMailFrom"].Value.ToString();
String SendMailTo = Dts.Variables["EMailTo"].Value.ToString();
String SendMailSubject = Dts.Variables["EMailSubject"].Value.ToString();
String SendMailBody = Dts.Variables["EMailBody"].Value.ToString();
//User::EMailBody,User::EMailFrom,User::EMailSubject,User::EMailTo
try
{
MailMessage email = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("mail.name.com");
// START
email.From = new MailAddress(SendMailFrom);
email.To.Add(SendMailTo);
email.Subject = SendMailSubject;
email.Body = SendMailBody;
//END
SmtpServer.Port = 993;
// SmtpServer.Credentials = new System.Net.NetworkCredential(SendMailFrom, "your password");
// SmtpServer.EnableSsl = true;
SmtpServer.Send(email);
MessageBox.Show("Email was Successfully Sent ");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
// Close Script Task with success
Dts.TaskResult = (int)ScriptResults.Success;
}
#region ScriptResults declaration
enum ScriptResults
{
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
};
#endregion
}
}