July 30, 2008 at 12:35 pm
Hello,
I have a straight forward SSIS package that traverses a FTP folder and locates new files uploaded within the last hour. If a new file is found then it sends out an e-mail via the send mail task with the names of the files added in the body of the e-mail.
This package works as it should in the BIDS debug environment. It also runs without any errors on the SQL Server where it's deployed. The only problem is that I'm not getting the e-mails when a new file has been uploaded. Basically I get a success start and a success complete but no e-mail.
Any ideas what may be causing my issues.
Environment Notes:
1.) In our LAN we have the MS Exchange server that the send mail task uses for the SMTP connection.
2.) The SQL Server is my personal desktop computer running SQL Server 2005 Standard Edition.
😀
July 30, 2008 at 12:38 pm
I had this issue on my personal PC because McAfee has a port blocking rule that blocked SMTP except from registered programs.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 12:43 pm
So you were able to run the SSIS package successfully in the Visual Studio environment but Mcafee was blocking the SMTP message from SQL Server.
Our network admin will have to help me with this one.
I will let you know the outcome.....Thanks for the input so far.
😀
July 30, 2008 at 1:08 pm
You also have to make sure your exchange server is configured to allow you to use it as an SMTP relay. I think, by default, it allows relay to addresses in the GAL, but there are a lot of options around securing this and your exchange admin may have disabled it.
July 30, 2008 at 1:31 pm
I actually encountered the problem in BIDS where my process would run but the SendMail task would fail. One way to test it on the SQL Server is to try to send an email using Database Mail. If that works then the issue is not anti-virus.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply