Using The Data Mining Query Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS I discussed how to use the Analysis Services Processing Task to process an “Adventure Works DW Standard Edition” sample database which is available for SQL Server 2008 and we also discussed, how to backup an Analysis Service Database using Analysis Services Execute DDL Task which is available in SQL Server 2005 Integration Services and later versions. In this article I will examine the use of the Data Mining Query Task which is available in SQL Server 2005 and later versions.

Read more...