I downloaded the smtptask.exe from sqldev.net and installed it. I drag this new task into a brand-new dts package and provide all necessary inputs. But, I get this error consistently when I attempt to execute.
(800403F4), Description = SMTP Mail Task: Execute() failed
I'm sure there are many out there who used this utility, please share your thoughs on what you did to fix it.