Ssis Send Mail Task: Error: An Error Occurred With The Following Error Message: "the Operation Has Timed Out."

SSIS package in question runs a series of stored procedures and fills 13 different excel files with results and sends those excel files to 13 different users in attachments. Packag

Solution 1:

I think I figured it out why this was happening. In case somebody / anybody is interested, here is what I think has happened. I was trying to expand the timeout period thru a script task, playing with Threading.Thread.Sleep value but I neglected to do the same in my SMTP connection properties. When I changed the timeout value in properties for SMTP connection, error messages stopped coming :)

I wish I could post a picture to show you where exactly that property is located but my reputation failed me!.. :( (less than 10 points yet)

I am in the process of completing all of my changes then I will post again with final result hoping that will resolve all of my problems.

Thanks to all who showed interest.