Database Reference
In-Depth Information
■
in Figures 8-3 and 8-4, the two data path arrows represent a blue data flow path and a red error output
path. Previous versions of sQl use green for the data flow rather than blue, but the function is the same. For more
information, see “data Flows: data Flow Paths” later in this chapter.
Note
Figure 8-4.
Editing a data source
The OLE DB Source Editor
Selecting Edit from the context menu shown in Figure
8-4
launches the OLE DB Source Editor window—
a window that you will become quite familiar with if you work with SSIS for any length of time!
The OLE DB Source Editor window consists of three separate pages:
•
he Connection Manager page
•
The Columns page
•
he Errors Output page
he Connection Manager Page
On the Connection Manager page, select which connection manager object to use from the “OLE DB connection
manager” dropdown box (Figure
8-5
). If you have not previously created a connection manager for the SSIS
package, the dropdown box will not offer any selections. The connection mangers are typically created first, but if
you have not done so yet, click the New button and create one.
■
one connection manager can be used by many different data flow components. it is a common mistake for
developers to create a new connection for each separate component using the new button.
Tip
