SQL Server Integration Services (SSIS) is an enterprise-level data ETL tool, which can be used for a multitude of purposes, including the processing of Analysis Services objects. SSIS is a huge product in its own right and even the discussion of its capabilities is well beyond the scope of this book. In this section, you will learn how to create a simple SSIS package that processes various SSAS objects. You could extend the SSIS solution to include a variety of tasks, such as extraction of data from source systems, populating a staging area, populating a Star schema data warehouse, and so on.
To create a SSIS package for processing SSAS objects, perform the following steps:
Open SSDT and navigate to File | New Project. Choose Integration Services Project from the business intelligence templates and provide a descriptive name for the project.
Drag Analysis Services Processing Task from the SSIS toolbox...