O'Reilly logo

Professional SQL Server™ 2005 Integration Services by Mike Murphy, Haidong Ji, Jason Gerard, Erik Veerman, Andy Leonard, Kathi Kellenberger, Douglas Hinson, Darren Green, Allan Mitchell, 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

4.3. Destinations

Inside the data flow, destinations accept the data from the data sources and from the transformations. The architecture can send the data to nearly any OLE DB–compliant data source, a flat file, or Analysis Services. Like sources, destinations are managed through the Connection Manager. The configuration difference between sources and destinations is that in destinations, you have a Mappings page (shown in Figure 4-11), where you specify how the inputted data from the data flow maps to the destination.

Figure 4.11. Figure 4-11

You won't be able to configure the destination until it is connected to the data flow. To do this, select the source or a transformation and drag the green arrow to the destination. If you want to output the bad data to a destination, you would drag the red arrow to that destination. If you try to configure the destination before attaching it to the transformation or source, you would see the error in Figure 4-12.

Figure 4.12. Figure 4-12

4.3.1. Data Mining Model Training

The Data Mining Model Training destination can train an Analysis Services data mining model by passing it data from the data flow. You can train multiple mining models from a single destination and data flow. To use this destination, you would select an Analysis Services ...

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