Preface
[ 2 ]
What This Book Covers
Chapter 1 will see the various roles played by SSIS in the enterprise business. You
will also learn about the various objects used in SSIS, most importantly the Package
object; the Control Flow Elements; the Data Flow Components; the Event Handlers,
and other miscellaneous features of the VS 2005 IDE.
Chapter 2 will take a look at how to create your first business intelligence project for
SSIS using the Visual Studio 2005 IDE. You will be introduced to the many windows
that are used by SSIS specifically, and a few other windows of the VS 2005 IDE used
for projects and solutions. The hands-on exercise at the end of the chapter helps you
to examine on your own the key features of the IDE as well as how you may retrieve
a VS 2005 created package using the SQL Server 2005 Management Studio.
Chapter 3 will cover how to send a mail by creating the Send Mail Task using the
SMTP server that you can access. If you are not sure about your SMTP Server, you
may find that Hands-On Exercise 2 gives you a better understanding of how to
access the SMTP server.
Chapter 4 will take a look at how to create a SSIS package that transfers a table on
your SQL Server 2005 to a flat file on your C:\ drive. You will also learn how to work
with the Connection Managers that are so essential for data transformation tasks.
Chapter 5 will see how to create a SSIS package that transfers a table on your SQL
Server 2005 database to an Excel spreadsheet.
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25