ssas ssis_使用SSIS操纵SSAS OLAP多维数据集

ssas ssis

There are many operations that we may run while working with OLAP cubes such as cube and partitions processing, executing administrative tasks, performing analysis and more… Three query languages that are used to run these operations: multidimensional expressions (MDX), data mining expressions (DMX) and XML for Analysis (XMLA). We can mainly write and execute these queries in SQL Server Management Studio, but many times we need to implement them within a flow that executes other tasks over other services (database engine, file system…)

在使用OLAP多维数据集时，我们可能会运行许多操作，例如多维数据集和分区处理，执行管理任务，执行分析等等。三种用于运行这些操作的查询语言：多维表达式（MDX），数据挖掘表达式（ DMX）和XML for Analysis（XMLA）。 我们主要可以在SQL Server Management Studio中编写和执行这些查询，但是很多时候我们需要在通过其他服务（数据库引擎，文件系统等）执行其他任务的流程中实现它们。

In SSIS, the below three tasks and two components are used to execute a command over SSAS:

在SSIS中，以下三个任务和两个组件用于通过SSAS执行命令：

1. Analysis Services Processing Task
   分析服务处理任务
2. Analysis Services Execute DDL Task
   Analysis Services执行DDL任务
3. Data Mining Query Task
   数据挖掘查询任务
4. Dimension Processing component
   尺寸处理组件
5. Partition processing component
   分区处理组件

Note that tasks can be used within the package control flow, while components are used within data flow tasks.

请注意，可以在包控制流中使用任务，而在数据流任务中使用组件。

In this article, we will give an overview of the first two tasks provided by Integration Services (SSIS) that allows manipulating OLAP cubes and executing commands over SSAS. These two tasks are Analysis Services Processing Task and Analysis Services Execute DDL Task.

在本文中，我们将概述Integration Services（SSIS）提供的前两个任务，这些任务允许操作OLAP多维数据集并通过SSAS执行命令。 这两个任务是Analysis Services处理任务和Analysis Services执行DDL任务。

连接到SSAS实例 (Connecting to an SSAS instance)

Before describing tasks and components, we should mention that we have to use the OLE DB Connection Manager to connect to an SSAS instance using Microsoft OLE DB for Analysis Services provider.

在描述任务和组件之前，我们应该提到我们必须使用OLE DB Connection Manager来使用Microsoft OLE DB for Analysis Services提供程序连接到SSAS实例。

You can add an OLE DB connection manager from the connection managers tab, and then from the providers drop-down list, you have to choose the Analysis services provider.

您可以从“连接管理器”选项卡中添加OLE DB连接管理器，然后从提供程序下拉列表中选择Analysis Services提供程序。