Earlier we stopped short of completing the OLE DB
Destination Component. Now that a HR.DEPARTMENTS
table has been created, the OLE DB Destination Data Flow
configuration can be completed. When you right click on SQL2k5 Destination
Data Flow Component and then click on Edit…menu item you will see the window
shown in Figure 52.
Figure 52
Click on the Microsoft Visual Studio
message's Yes button to open the Configure
OLE DB Destination Editor. Now from the drop-down you may click and
choose the HR.DEPARTMENTS table.
Figure 53
.
When you click on "Mappings" in the Left-hand side
you will see the window shown in Figure 54 since we have not yet established a
path for the data flow. The source and destination are disjointed.
Figure 54
Add a Path for dataflow
The path from Source to Destination may be created by
clicking on the Add Path drop-down menu item. When
you right click the Source Data Flow Component, as
shown in Figure 55, you will get access to the drop-down menu.
Figure 55
This brings up the Data Flow window with the
"From:" showing the Source and the SQL2k5 Destination can be set from
the "To:" drop-down as shown in Figure 56.
Figure 56
When you click on the OK button on
the Data Flow window you will see the window in
Figure 57. From here you need to choose the appropriate output.
Figure 57
From the two outputs choose the correct one for mapping. The
OLE DB Source output (from Oracle) will be connected to the OLE DB Destination
input (SQL 2005 Server table).
Figure 58
When you click on the OK button on
the above window, the path for data flow will be set. This should practically
complete the package.
