You may review how the data flows from Excel Source to the Data Conversion
item by looking at how the path is configured.
5. Make a right-click on the path and choose Edit??¦. This brings up the Data
Flow Path Editor window. Click on Metadata on the left-hand side.
This displays the Metadata of the data in the path as shown in the following
screenshot. The data types shown are SSIS defaults for the Excel Source.
6. After reviewing the Metadata, click on the Cancel button.
Chapter 10
[ 167 ]
Step 4: Configuring the Data Conversion Data
Transformation
1. Right-click the Data Conversion item in the Canvas and choose Edit??¦ from
the drop-down menu.
This opens the Data Conversion Transformation Editor as shown in the
following screenshot. When it gets displayed, the bottom pane will be empty
and the table columns in the top pane will be unchecked. In the next
mini-step, you will make changes as suggested in the Editor.
On Using a Data Conversion Data Flow Transformation
[ 168 ]
2. Place a check mark in all the columns. Change the Output Alias column
names so that Copy of eName will be dcName, etc.
The Data Type that initially shows up is what SSIS has determined
appropriate. If you go ahead with these values, you will probably,
successfully make an error-free conversion.
3. Using drop-down controls change the Data Type to have the
following values:
dcName: Unicode string[DT_WSTR]
dcDate: date[DT_DATE]
dcHeight: Numeric Precision:18, Scale:3
dcCost: Decimal[DT_DECIMAL]: Scale:3
The incoming data will be converted to the above data types after the
transformation becomes effective.
Pages:
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127