Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
callawayx14
Yak Posting Veteran
73 Posts |
 Posted - 2012-04-13 : 11:05:37
|
| 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? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-13 : 11:29:24
|
| 1. Are you trying to send it to an external email address?2. is the email address valid3. 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 SMTPetc ....<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
callawayx14
Yak Posting Veteran
73 Posts |
Posted - 2012-04-13 : 11:50:34
|
| Thank you for your prompt reply.The Email address is Internal (Currently my own)The attachment is quite small 42kb .xlsxI’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.NetworkCredentialDo you think this is something that has to worked out on the SMTP/Exchange? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-13 : 12:14:01
|
| 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 |
|
|
|
callawayx14
Yak Posting Veteran
73 Posts |
Posted - 2012-04-13 : 12:23:15
|
| 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!! |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-13 : 12:30:01
|
| hope it works out . please let us know if that worked so others can benefit<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
SSIS Send Mail Task