Search code examples
ssiscube

How to delete Cube partition in SSIS


How can I delete a cube partition in SSIS ? I I have seen this example which shows how to create cube partition in SSIS but I am not able find tutorial for deletion of a cube partition.


Solution

  • Using AMO, a Partition object has a Drop method.

    myPartition = myMeasureGroup.Partitions.FindByName("Partition_Name");
    if ( myPartition != null)
         myPartition.Drop();