I am trying to execute send mail task, I am getting following error. "[Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. k8sm412030vdv.39"."

How do you execute your package? Is it running under SQL Agent's account?Arthur My Blog

I hope I have found the answer in our forum by CozyRock: The standard SMTP connection doesn't allow specification of credentials. You have to implement a script. Check the script here for reference. Full thread: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/66894f0a-3ff4-4473-b4dc-89f13ef3359c/ Arthur My Blog

I am executing independently....kmp

What do you mean?Arthur My Blog

Thanks ArthurZ, It works....kmp