Metadata Collection - SQL Server Integration Services Design Patterns - page 23

You can now return to your Integration Services package. You do not need to per-
form any data cleansing or data transformations in this Data Flow task, so you'll pro-
ceed straight to storing your results. Select the OLE DB Destination item from the tool-
box, drag it onto the designer surface, and rename it Central Logging Destination .
Connect it to the OLE DB Source by dragging the blue data flow arrow from the
source to the destination. Double-clicking the OLE DB destination brings up another
editor. This time, select your dbaCentralLogging connection from the OLE DB
Connection Manager drop-down. Leave Table or View - Fast Load selected in the Data
Access Mode drop-down. In the Name of the Table or the Vew drop-down, select
[dbo].[dba_monitor_databaseGrowth], as seen in Figure 1-16 .
Figure 1-16 . Editing the OLE DB Destination Editor's connection manager
When you're done with the Connection Manager page, click the Mappings menu.
You'll notice that Integration Services has taken the liberty of performming an initial
mapping based on column names. Although this is a nice time-saving feature, be wary