Sending Email with a SSIS Package
[ 84 ]
Hands-On Exercise Two: How to Find
Your ISP's SMTP Server?
On your desktop, you probably have email programs such Outlook Express, which is
most common, and Microsoft Outlook. I have Outlook Express 6. You can find your
ISP's SMTP server from the menu item Tools in Outlook Express, which displays a
drop-down menu from which you choose Accounts. When you click on Accounts,
it opens up the Internet Accounts window. On this window, choose the MAIL tab
and click on the Properties button on the right of the window, after highlighting
your Account in the above. It opens the properties for that account showing five tabs:
General, Servers, Connection, Security, and Advanced.
You will find the SMTP server's correct name in here under Server tab, as shown in
the next screenshot.
Chapter 3
[ 85 ]
Summary
The Send Mail Task was chosen as it is the most ubiquitous program used .
The Hands-On Exercise guides you through the process of configuring the task and
executing the task. If you do not have an email program on your desktop (known as
an email client) you may use the SMTP Server of your favorite web email, such as
Google (http://hodentek.blogspot.com/2007/06/configuring-web-emailssmtp-
and-pop.html) or Yahoo. Depending on the geographical region, you may
choose an SMTP server from this comprehensive list of SMTP Servers
(http://www.e-eeasy.com/SMTPServerList.aspx). You may also find some free
(http://www.
Pages:
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74