How to insert SMTP host port in Send Mail Task in SSIS

Last Post 11 Aug 2008 11:41 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
peymaster
New Member
New Member

--
06 Aug 2008 06:55 AM
I have a SSIS package that uses Send Mail Task. The task can send emails to any accounts within our domain, but not outside of our domain due to our firewalls. I need to tell the Send Mail Task which port to use to send out emails. I did the samething with database mail setting, telling it which port to use, and it works just fine.

So, any ideas how I can tell Send Mail Task (or SMTP connection) within SSIS which port to use? Thank You.
SQLUSA
New Member
New Member

--
11 Aug 2008 11:41 PM
Check out this article:

http://msdn.microsoft.com/en-us/lib....port.aspx

Let us know if useful.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/


Acceptable Use Policy
---