Hands-On Microsoft SQL Server 2008 Integration Services part 39. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 358 Hands-On Microsoft SQL Server 2008 Integration Services To train the data mining models using this destination you need a connection to SQL Server Analysis Services where the mining structure and the mining models reside. For this you can use Analysis Services Connection Manager to connect to an instance of Analysis Services or to the Analysis Services project. The Data Mining Model Training Editor has two tabs Connection and Columns in which you can configure the required properties. In the Connection tab you specify the connection manager for Analysis Services in the Connection Manager field and then specify the mining structure that contains the mining models you want this data to train. Once you select a mining structure in the Mining structure field the list of mining models is displayed in the Mining models area and this destination adapter will train all the models contained within the specified mining structure. In the Columns tab you can map available input columns to the Mining structure columns. The processing of the mining model requires data to be sorted which you can achieve by adding a sort transformation before the data mining model training destination. DataReader Destination When your application needs to access data from the data flow of an SSIS package you can use the DataReader destination. Integration Services can provide data straight from the pipeline to your application in cases where you need dynamic processing to happen when users request using the DataReader interface. SSIS data processing extension facilitates provision of the data via the DataReader destination. An excellent use of the DataReader destination is as a data source for an SSRS report. The DataReader destination doesn t have a custom UI but uses the Advanced Editor to expose all the properties organized in three tabs. You can specify Name Description LocaleID and ValidateExternalMetadata properties in the Common Properties section of .
