Share via

  • Article

Data Mining Query Transformation

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 Creating DMX Prediction Queries.

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.

Configuring the Data Mining Query Transformation

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 How to: Set the Properties of a Data Flow Component.

External Resources

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.