Using the Send Mail Task in SSIS with Microsoft Exchange server as your SMTP
Tuesday, January 6th, 2009I have already done a similar post on this but the basics are:
- turn on delay validation so you don’t have to enter an email address in the *to* field -> you can use expressions to read it from a table or recordset etc
- configure your exchange server like so
- Launch your Exchange System Manager
- Navigate to your server -> Administrative Groups -> Admin Group -> Server Name -> Protocols -> SMTP
- Right click on the “Default SMTP Virtual Server”
- Click the access tab
- Press the Relay button and add the IP of the machine that wishes to use this as their SMTP server.
- Fun times.