Hands-On Exercise: Transferring Data to
an Excel File
This exercise consists of the following major steps:
Creating a BI project and adding a Data Flow Task.
Configuring the DataReader's Connection Manager.
Configuring the DataReader Source.
Adding a Character Map Transformation.
Adding an Excel Destination and establishing a path to it from the Character
Map Data Flow Component.
Configuring the Excel Destination Component.
Testing the package.
??? ??? ??? ??? ??? ??? ???
Transferring Data to a Microsoft Excel File
[ 100 ]
In order to follow the steps as indicated, you will need a source and a destination:
the source data is extracted from the MyNorthwind database (just a renamed version
of the Northwind database) on the SQL Server 2005 Server, and the destination is
loading this to an MS Excel 2003 spreadsheet file on your hard drive. You also need
to establish a path connecting them. In addition, you will also interpose a Character
Map Data Flow Task that will convert the text in one of the data fields, so that all
characters in that column are capitalized after the transformation.
Step 1: Creating a BI Project and Adding a
Data Flow Task
In this section, you will be creating a Business Intelligence project and changing the
name of the default package object. Since it is data-related, you will be adding a
Data Flow Task. You will also be adding a DataReader component to the data flow.
1. Create a business intelligence project Ch 5 as described in Chapter 2 or
Chapter 3.
Pages:
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84