Hello. I’ve attempted to send a file created in my data flow. I tried using the Send Mail Task which failed over and over. I’ve abandoned that am trying to use the Script Task instead. I Believe the Send Mail task was failing do to Anonymous Login and or Windows Authentication. I’m actually using an exchange server within our organization. In the Script task I pass my Network Credentials and port 80. The task hangs forever on actual send portion of the script. It does not fail…but hangs and hangs. Does anyone have any suggestions?
1. Are you trying to send it to an external email address? 2. is the email address valid 3. How big is the attachment you are trying to send (Exchange admin could have things locked down as far as size) 4. What are you trying to send: .doc, zip, xml , etc (some attachments are considered dangerous) 5. Talk to your Exchange admin regarding SMTP because you cannot use Exchange SMTP if your server (ssis) is not explicitly set as a customer of the SMTP
etc ....
<><><><><><><><><><><><><><><><><> If you don't have the passion to help people, you have no passion
Thank you for your prompt reply. The Email address is Internal (Currently my own) The attachment is quite small 42kb .xlsx I’m certain my server (ssis) is not explicitly set up as a customer of the SMTP. This is why I’m attempting to pass my System.Net.NetworkCredential Do you think this is something that has to worked out on the SMTP/Exchange?
I believe it is something that has to worked out on the SMTP/Exchange. imagine if anybody within the network could send email using a script. that would not be a desirable thing. This same thing happened to me once and we have to explicitly set SMTP on our mail server. Exchange is port SMTP 25, port 80 is http am I correct?
<><><><><><><><><><><><><><><><><> If you don't have the passion to help people, you have no passion
ok...That was what I was thinking as well. That either the default ports 25 (smpt) or 80 (htm) have not been used as extra security meassure or the SMPT/Exchange does not except relays to prevent spaming etc. Thank you for your help. I appreciate it!!
SSIS Send Mail Task
Posted - 04/13/2012 : 11:05:37
