Summary
This chapter described the following:
Configuring data flow components that are necessary for transferring data
from single table on the SQL Server 2005 to an Excel file.
The usage of a Character Map Data Transformation component.
The reverse of this transfer can be accomplished by choosing an Excel Source and an
SQL Server Destination.
??? ???
Data Transfer to an
MS Access Database
This chapter shows you how to create a package that can transfer data from an
SQL Server 2005 database to a Microsoft Access Database. You will also learn how
to use a Data Viewer to monitor the data flow. Recently, Microsoft released the 2007
version, but this chapter will be using the 2003 version of this product.
In the Hands-On Exercise, you will be transferring data retrieved from an SQL
Server 2005 table to an MS Access database's table. You will be using a Data Flow
Task consisting of a source connected to an SQL Server 2005-based connection
manager, as in the previous chapter, and a MS Access database accessed via an OLE
DB Destination. You will also learn the usage of a Data Viewer for monitoring the
data flow.
Hands-On Exercise: Transferring Data to
an Access Database
In order to execute the steps as indicated, you will need a source and a destination;
the source data is extracted from SQL Server 2005 and the destination is an
MS Access Database table. You also need to establish a path connecting them. In
addition, you will also incorporate a Data Viewer that will monitor the flow from
the source to the destination.
Pages:
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92