Analysis Services Execute DDL Task

DDL Means Data Definition Language. This Task runs DDL Statements that can create ,drop or alter the mining models and Multi dimensionals objects such as cubes and dimensions.

For Example, by using this task with proper DDL, we can create Partition in cube the (OLAP Databases).

DDL Statements are represented as statements in

• Analysis Services Scripting Language (ASSL) - It is used to define and describe an Instance of Analysis Services, Databases and Database Objects
  
• XML For Analysis (XMLA) Command - It is used to send action command such as alter, create, drop or process the OLAP Objects

We need Analysis Services connection to execute this task, also if we want to execute DDL which is stored in the separate file, then we need to create File connection to that file