3. In the Component Properties tab, type in the following SQL Command into
the textbox corresponding to the SQLCommand (which comes up empty
at first) or type the statement in the String Value Editor that pops-up when
you click on an empty area along the line item, SQLCommand under Custom
Properties node in the Component Properties tab of the editor.
"Select [ProductName], [QuantityPerUnit], [UnitPrice],
[ReorderLevel] from Products"
??? ??? ???
Chapter 6
[ 113 ]
Caution: You cannot directly copy and paste the SQL statement from the
SQL Server as each column needs to be enclosed by the square braces.
This query will allow the DataReader to read the data from the four columns.
A sample of the table data is shown in the following screenshot, taken from
SQL Server 2005's Management Studio.
4. Click on the Column Mappings tab. In doing so, you open the Column
Mappings page in the Advanced Editor for DataReader Source, showing
the columns that are the output of the DataReader.
For this tutorial, no modifications are made to the Input and Output properties page.
Step 4: Adding an OLE DB Destination and
Establishing a Path from the DataReader
Component
In this step, we will add an OLE DB Destination. We will then establish a path from
the DataReader Source to the OLE DB Destination.
1. Add an OLE DB Destination component from the Data Flow Destinations
group in the toolbox to the Data Flow page.
This can be accomplished either by a double-click of the component in the
Toolbox or a drag-and-drop operation as described in previous chapters.
Pages:
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94