Once you have created a data mining model, such as a Decision Tree, or Neural Network, you normally want to create some predictions. This is easily done using the “Data Mining Query”  transformation in SSIS. SSIS is particularly useful if you need to create  predictions on  large data sets, or need to apply apply additional transformations to the data. This video demonstrates the process to embed a previously created predictive model inside SSIS in order to create predictions. If you haven’t created a data mining model before, its also worth taking a look at this earlier  video  first.