Using SQL Server Integration Services to process Analysis Services objects
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.
How to do it...
To create a SSIS package for processing SSAS objects, perform the ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
