Reputation: 6530
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.
Upvotes: 0
Views: 890
Reputation: 1836
Using AMO, a Partition object has a Drop method.
myPartition = myMeasureGroup.Partitions.FindByName("Partition_Name");
if ( myPartition != null)
myPartition.Drop();
Upvotes: 1