Database Reference
In-Depth Information
Figure 8-14.
Configuring an OLE DB data destination
Each data destination component can look slightly different depending on which type of destination
component you use. The SSIS Toolbox has several data destination components to choose from, but you are likely
to use the OLE DB destination the majority of the time. Therefore, we focus on the settings of this type of data
destination.
■
if you are using an olE dB source task, you should choose the olE dB destination versus the sQl
server destination, even when you are importing data into a sQl server database. Although the sQl server destina-
tion works, it may expect different metadata types than the olE dB destination provides. if you try to use an olE dB
data source with a sQl server destination, you can anticipate errors unless you have transformed all the data types
appropriately.
Important
he Connection Manager Page
On the Connection Manager page, set the connection to point to your destination table and decide what access
mode you are going to use (Figure
8-15
).
