August 12, 2013 at 3:39 am
I have a package created in SSIS 2008. Here i have used ForEachLoopContainer and in side this loop container one Send Mail Task,here we gets the number of email addresses from a database table and and send mail to these email address.
But some time suppose any emailaddress is not valid and in case user doesn't exists now then i want Send Mail task to ignore this illegal email address and continue for others email addresses and make the task to success.
Please let me know how i can achieve this?
August 13, 2013 at 6:53 am
Did anybody have a solution for this?
August 13, 2013 at 4:44 pm
If you want to continue processing after a task error, you can use the Propagate property of the mail task. I recently blogged about this design pattern here: http://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/
If you're using this property to prevent the failure of a pack in the event of a bad email address, I recommend also using the On Failure precedence constraint (also covered in the same blog post) to log any invalid addresses so they can be cleaned up or removed.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply