The data types are the ones that are available in
MS Access 2003.
Set the attributes of each of the columns as shown here (these were arbitrarily
chosen, Field Size for AccName was chosen to generate error):
AccName??”Data Type: text; Field Size: 15; Allow Zero Length:No
AccDate??”Data Type: Date/Time; Format; General Date
???
???
??? ???
Chapter 10
[ 161 ]
AccHeight??”Data Type: Number, Field Size: Single; Decimal Places:2
AccCost??”Data Type: Number; Field Size: Long Integer; Format Currency,
Decimal Places: 3; Default Value: 0
None of these are required. None of these are indexed.
??? ???
On Using a Data Conversion Data Flow Transformation
[ 162 ]
Hands-On Exercise: Transferring Data to
an Excel File
This exercise consists of the following major steps:
Creating a BI project; adding a Data Flow Task and configuring an
Excel Source.
Adding a Data Conversion Data Flow Transformation.
Establishing a path from Excel Source to Data Conversion Data Flow
Transformation.
Configuring the Data Conversion Data Flow Transformation.
Adding and configuring an OLE DB Data Destination.
Adding and Configuring a Recordset Destination for displaying errors.
Building the project and testing the package.
Step 1: Creating a BI Project; Adding a Data
Flow Task and Configuring an Excel Source
Create a BI project Ch 10. Change the name of the default package to DCnvrt.dtsx.
Drag and drop a Data Flow Task to the Control Flow Page.
1.
Pages:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124