O'Reilly logo

Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services by Mike Davis, Devin Knight, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Loading Data to a Destination

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. 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.

OLE DB Destination

The most common type of destination is the OLE DB Destination. It can write ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required