You will also learn how to connect to
an Excel data destination.
Chapter 6 will create a package that transfers data from a table on SQL Server 2005
to a MS Access Database. You will learn how to work with the Data Viewer that
monitors the data flow.
Chapter 7 will create a package that uses the Bulk Insert Task to transfer data in a text
file on your computer to a table in the SQL Server 2005. You will also learn about
creating a table on SQL Server 2005 using the Management Console.
Chapter 8 will create a package that conditionally splits the data from a SQL Server
2005 query and sends them to multiple destinations. You will also learn to work with
Recordset Destination, an in-memory ADO Recordset Object, and use it to display
the results of data splitting. In addition, you will learn about using Variables in a
SSIS Package.
Chapter 9 will create a package that can aggregate data from a database using the
Aggregate Data Transformation. You will extract data from a SQL Server 2005 and
load it into a Recordset Object to review the aggregated results.
Preface
[ 3 ]
Chapter 10 will create a package that converts the data extracted from an Excel spread
sheet source before loading it into a MS Access Database. You will also learn how to
direct the data that is not accepted by the destination to another destination using the
errors in data transformation.
Chapter 11 will create a package that shows you how to work with the XML Task.
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