This window shows both the incoming and outgoing data types using the
Data Conversion Object.
Setting Up a Connection Manager
1. Right-click the OLE DB Destination object and choose Edit to display the
OLE DB Destination Editor.
In this window, you will see a list box displayed on the left with the
following items: Connection Manager, Mappings, and Error Output. On
the right, you will see only the Data access mode field displaying Table or
View. The OLEDB connect manager and Name of the table or view fields
are empty.
2. Click on the New??¦ button alongside OLE DB connection manager: label.
This opens the Configure OLE DB Connection Manager window.
3. Click on the New... button on that window.
This will display the Connection Manager window.
On Using a Data Conversion Data Flow Transformation
[ 170 ]
4. Using the drop-down handle alongside Provider:, choose Microsoft Jet 4.0
OLE DB Provider.
The items in the bottom of this screen changes to show required items for an
MS Access database.
5. Click on the Browse... button and from C: drive choose the C:\DataConvert.
mdb file. The User name: default is Admin and no need for a password as the
present user is also the owner. You may also test the connectivity using the
Test Connection button.
6. Click on the OK button after this, the C:\DataConvert.mdb will be added
to the Data connections: list box on the left of the Configure OLE DB
Connection Manager's window. Click on the OK button on this window.
Pages:
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129