After you have set up a source to bring the needed data to the Data Flow you need somewhere to put it. A destination accepts data from data sources or transformations and sends them to the location specified in the destination's connection manager.
The difference between configuration of sources and destinations is the Mappings page shown in Figure 15-1. The Mappings page points each column from your Data Flow's pipeline to each column that is available in your destination. By default, SSIS will match columns together with the same name, but you can easily match columns by dragging one of Available Input Columns to the appropriate Available Destination Columns if your column names do not correspond. As you can see in the figure, it is not mandatory that these columns be in the same order from the source to the destination.
Figure 15-1. Figure 15-1
Until the destination is connected to the rest of pipeline you cannot configure it. To make the connection, select the source or a transformation and drag the green arrow to the destination. If you want to output a transformation's bad data to a destination, you would drag the red arrow to that destination. In this lesson the most frequently used destinations (OLE DB, flat file, and Excel) are demonstrated.
The most common type of destination is the OLE DB Destination. It can write ...