In this recipe, you are going to use the data mining query transformation. Based on the Naive Bayes model built in the previous recipe, you will use a (Data Mining Extensions (DMX) prediction query to get predictions from the SSAS mining model for the test dataset you created in the first recipe of this chapter.
In order to test this recipe, you need to have SSAS installed in multidimensional and data mining mode. In addition, you need to finish the first and third recipes of this chapter.
- Add a new package to the
Chapter08
project. Rename itDataMining.dtsx
. - In the control flow of the package, add a new data flow task by dragging it from the SSIS toolbox to the control flow work area.
- Click the
Data Flow
tab to open theData Flow Designer
. - Create a new OLE DB source. Name it
TMTestSet
...