» Using the Send Mail Task in SSIS with Microsoft Exchange server as your SMTP laurasaur

Using the Send Mail Task in SSIS with Microsoft Exchange server as your SMTP

January 6th, 2009 § 1 comment

I 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.

You are currently reading Using the Send Mail Task in SSIS with Microsoft Exchange server as your SMTP at laurasaur.

.

4HB baby bad times baking breakfast brownies cake caramel cheesecake chocolate computing cookies cupcakes cute Extended Rear Facing family feeding Flavours food fruit geek goal fail good times home home theatre Knitting London mains New Zealand Paleo pie pregnancy Protein pudding reviews sleep slice TechEd 2008 Travel Uncategorized Vanilla web services Weight Loss wilton work
.
Blogroll
share the love
- laurasaur on Paleo/Low Carb/Gluten Free Banana Cake
- Carla Riccio on Paleo/Low Carb/Gluten Free Banana Cake
- » Banana Cake laurasaur on banana cupcakes
- MaryLouise on Chocolate Macarons with Espresso Buttercream
- halle on white chocolate caramel oat cake
Subscribe to Blog via Email

Enter your email address to subscribe to laurasaur and receive notifications of new posts by email.
Disclaimer

This is my own personal blog written and owned solely by me. Please do not use my pictures without receiving permission from me. You are welcome to link to my recipes as long as long as you link back to my blog and give me credit. Everything here is my own opinion and not meant to be taken seriously or to replace any advice given by your doctor. In fact you may want to see a doctor after making some of these recipes. I dont mean to offend anybody and won't be held responsible for anything you do or see here PEACE OUT.