SSIS Jobs that involves sending out email have experienced intermittent interruption due to the following exception error: [Send Mail Task] Error: An error occurred with the following error message: "Error in processing. The server response was: 4.7.0 Timeout waiting for client input". This issue is happening only when the DFT task is taking more time to complete the transaction and the following Sending mail task is getting failed.

the builtin Send mail Task hasn't good developed for debugging and troubleshooting, it is better to use script task for send mail, this is a sample: http://consultingblogs.emc.com/jamiethomson/archive/2006/07/03/SSIS_3A00_-Sending-SMTP-mail-from-the-Script-Task.aspxhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com