SSIS2008 & Agent - SMTP (ScriptTask) and Send Mail Task Fails: The Operation has TimedOut
Good day, i need help. The Agent & Jobs were working fine last week, but this week its failing on Script Task (SMPT) & SSIS Send Mail Task on the Operation Has TimedOut. There was a problem with the exchange server which caused the first TimeOut but now the exchange server is fixed, i have in the script added the "TimeOut" property & set to 300 Seconds (100 default). Firstly, The weird part is that not all send mail/smtp tasks fail - the one would go thru (2mb zipped file) then the rest will fail. The tasks fail But some will still send mail later other wont (all other files are under 1mb but use to work for months) Secondly, A coleague made a change to the agent adding send database mail on the agant not to sure if this could be it but when i ran pkg in BIDS on Server it also failed. What is going wrong, is there a property somewhere but i had this set in the smtp but still fails Please Assist
June 24th, 2011 2:45am

This might be the property set by your exchange server that you can't send bulky mails. Please check with the mail server Admin. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2011 3:06am

I confirmed with admin & it is setup to send bulk emails as it worked last week, together with the first task in job sends successfully to about 50 users with attachment of 2mb but the next task within same pkg sending 100kb file to same user group fails. Now i cant say it the agent as i just ran a job I in BIDS on the server: System.Net.Mail.SmtpException: The operation has timed out But his same script works the second time around :( ?
June 24th, 2011 3:23am

I confirmed with admin & it is setup to send bulk emails as it worked last week, together with the first task in job sends successfully to about 50 users with attachment of 2mb but the next task within same pkg sending 100kb file to same user group fails. Now i cant say it the agent as i just ran a job I in BIDS on the server: System.Net.Mail.SmtpException: The operation has timed out But his same script works the second time around :( ? There should be nothing to be done on the SSIS side As you mention it is a random behavior of your package then problem exists with your SMTP server only. Might be Server is not available at certain time.. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2011 5:53am

I agree but admin says it cant - i said that the pkgs worked fine for months to all of a sudden to fail. I'm battling with them - I knew this but wanted to get advice from this forum if i was missing anything Thank You
July 2nd, 2011 8:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics