The Excel Destination also requires a connection manager.
The Excel Destination connects to an MS Excel on your hard dive using the
connection properties defined in a connection manager.
1. Right-click the Excel Destination and from the drop-down menu choose Edit.
This displays the Excel Destination Editor. Excel requires an OLE DB
connection manager and if there are no configured connection managers
(by you or a previous user) the drop-down will be empty.
2. Click on the New??¦ button.
The Excel Connection Manager window gets displayed as shown in the next
screenshot. Here, you need to use the Browse button and pick the Excel file
as the destination. The data will be written to the destination when the
package is run.
Transferring Data to a Microsoft Excel File
[ 108 ]
3. Open Windows Explorer and create an Excel file in the C:\drive.
For this tutorial, TableToXls.xls is chosen.
Besides connecting to an existing file, the Excel Connection Manager supports
creating a file on the folder of your choice in the machine using the
Browse??¦ button.
4. Now browse to the newly created file using the Browse??¦ button and choose
this file.
5. Click on the OK button in the Excel Connection Manager window.
6. For the Data Access Mode, accept the default, Table or View.
You have to indicate the name of the Excel sheet that will be used. (Do not
click on the drop-down for locating the sheet. The drop-down will show the
three Excel sheets that are found in a newly created Excel worksheet file; all
of them having just one column each.
Pages:
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90