15. Associate Available Input Columns with Available Destination Columns
as suggested schematically in the figure (as explained above). All four
columns need to be associated in this manner.
At present, we are not considering any error outputs.
Chapter 6
[ 119 ]
16. Click on the OK button in this screen.
This completes the extraction from the SQL Server, and loading it to the table
in the Access database. This package can now be executed.
17. Build and execute this package as in the previous exercises.
When executed, you will notice that both the data flow components turn green and
you can verify that the TblToAcc is now populated with data, as shown partially in
the next screenshot.
Step 6: Incorporating a Data Viewer to Monitor
Data Flow
Data Viewers in SSIS display data flowing in a data path connecting two data flow
components by stopping the flow at the point in which they are placed. The data
flow can be resumed by controls available on the Data Viewer. The data can be
viewed in four different ways, in a grid, a histogram, a scatter plot, and a column
chart. Data Viewers are excellent trouble shooting devices as they enable monitoring
the flow and diagnosing the bottle necks.
1. Right-click the green line, the Path connecting the DataReader Source and
the OLE DB Destination and from the drop-down menu choose
Data Viewers??¦.
Data Transfer to an MS Access Database
[ 120 ]
This brings up the following window, Data Flow Path Editor.
Pages:
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98