The Data Mining Query transformation performs prediction queries against data mining models. This transformation contains a query builder for creating Data Mining Extensions (DMX) queries. The query builder lets you create custom statements for evaluating the transformation input data against an existing mining model using the DMX language. For more information, see Data Mining Extensions (DMX) Reference.
One transformation can execute multiple prediction queries if the models are built on the same data mining structure. For more information, see Data Mining Query Tools.
Configuration of the Data Mining Query Transformation
The Data Mining Query transformation uses an Analysis Services connection manager to connect to the Analysis Services project or the instance of Analysis Services that contains the mining structure and mining models. For more information, see Analysis Services Connection Manager.
This transformation has one input and one output. It does not support an error output.
You can set properties through SSIS Designer or programmatically.
For more information about the properties that you can set in the Data Mining Query Transformation Editor dialog box, click one of the following topics:
The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:
For more information about how to set properties, see Set the Properties of a Data Flow Component.