I have created an SSIS package and trying to send auto e-mail after each task is completed. It appears the E-mail Task on SSIS has limitations. I have been told there maybe a way to use "Script Task" to accomplish my objective. Does anyone have any scripts or know good reference. Perhaps suggestions? Thanks!
Welcome to the forums. Look at this http://ssisctc.codeplex.com/ site which has relevant code for your amusement.
What limitations are you concerned with? You can use .NET email, but I try to use scripts only for things that have no component in SSIS since debugging a script is a little more difficult than debugging a component.