Automation of Data Mining Using Integration Services
SQL Server Technical Paper
Writer: Jeannine Takaki
Technical Reviewer: Raman Iyer
Published: July 2011
Applies to: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005
Summary: This article is a walkthrough that illustrates how to build multiple related data models by using the tools that are provided with Microsoft SQL Server Integration Services. In this walkthrough, you will learn how to automatically build and process multiple data mining models based on a single mining structure, how to create predictions from all related models, and how to save the results to a relational database for further analysis. Finally, you view and compare the predictions, historical trends, and model statistics in SQL Server Reporting Services reports.