Drag and drop an Excel Source item from the Data Flow Sources group in
the Toolbox to the Data Flow Page.
An instance of the Excel Source will be added to the DCnvrt.dtsx package.
2. Right-click the Excel Source item, and from the drop-down menu choose
Edit??¦.
This brings up the Excel Source Editor window.
3. In the Excel Source Editor that shows up, click on the New??¦ button.
??? ??? ??? ??? ??? ??? ???
Chapter 10
[ 163 ]
This opens the Excel Connection Manager page as shown below.
4. Click on the Browse??¦ button and locate the DataCnvrt.xls file and choose
the file.
This will bring the file to the Excel file path: field, shown in the
previous screenshot.
5. Click OK once the file name is displayed.
This will take you back to the Excel Source Editor. The OLEDB connection
manager: field gets an entry -"Excel Connection Manager". An icon will be
added to the Connection Managers' page. The Name of the Excel Sheet:
field is now enabled.
On Using a Data Conversion Data Flow Transformation
[ 164 ]
6. Click on the Name of Excel Sheet: drop-down and choose DataConvert$, as
shown in the following screenshot.
You may click on the Preview??¦ button to see how the sheet looks. The
preview runs a query and shows the original Excel sheet you started during
the preparatory step.
7. Click on Columns, shown in the left-hand side of the above screenshot.
This opens the Available External Columns and the Output Columns page,
as shown in the next screenshot.
Pages:
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125