Hands-on Exercise 1 helps you get
acquainted with the IDE using the instructions in the chapter. Hands-on Exercise 2
shows how you may import the package created by the project into the MS SQL Server
2005 Management Studio. Hands-on Exercise 3 shows how to launch the export/
import wizard to create packages in the SQL Server 2005 Management Studio.
Sending Email with a
SSIS Package
This chapter shows you how to create a SSIS package that can send an email using
the Send Mail Task. The Send Mail Task is based on an Internet Protocol called
SMTP, which stands for Simple Mail Transfer Protocol.
Sending and receiving email is a very common task. The email program on your
desktop uses two different servers: one for sending and the other for receiving. The
sending of emails is based on the Simple Mail Transfer Protocol described in RFC 821
(http://www.apps.ietf.org/rfc/rfc821.html). The Send Mail Task adheres
to this standard. Hands-On Exercise One shows how to configure the task and
Hands-On Exercise Two shows how to discover your accessible SMTP server. If you
are not too sure of an SMTP server that you can use for Hands-On Exercise One, you
may read Hands-On Exercise Two first.
Hands-On Exercise One: Sending an
Email Using the SMTP Server
For this exercise, you need to know the SMTP server that you can use for configuring
this task. You may also use the SMTP server of your web mail program.
1. Create a New BI project Ch 3 from the File menu using the drop-down item,
New, as described in Chapter 2.
Pages:
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68