)
7. Click on the New??¦ button.
You are creating a new Excel sheet. This pops-up a Create Table window
showing the columns that are being piped into the component, as shown in
the following screenshot.
Chapter 5
[ 109 ]
8. Click on the OK button, shown in the previous screenshot.
A new Excel Sheet, Excel Destination, will be added to the TableToXLS.xls
file. If you now open and review this file (TableToXls.xls) you will see the
column headers are added to this sheet.
9. Click on the Mappings in the left-hand-side pane of the Excel Destination
Editor, which shows the mappings from the input to the output.
This shows all the columns from the Character Map Data Flow Component
being written to the destination file, as shown in the following screenshot.
10. Click on the OK button in this window. The package is now completely
configured and ready for execution.
Transferring Data to a Microsoft Excel File
[ 110 ]
Step 7: Testing the Package
1. Right-click the TableToXls.dtsx in the Solution Explorer and from the
drop-down choose, Execute Package.
All three components on the Data Flow page turn green, indicating that
the package executed successfully without errors. You may review the
Progress tab in the 'Canvas', which shows all the details of the execution
of the package.
2. Now open up the TableToXLs.xls file and review.
A few rows of data are shown in the next screenshot. Notice that the
Character Map Data Transformation component has capitalized all the
characters in the CompanyName column.
Pages:
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91