Zerotoinfinity
Zerotoinfinity

Reputation: 6530

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.

Upvotes: 0

Views: 890

Answers (1)

Jeroen Bolle
Jeroen Bolle

Reputation: 1836

Using AMO, a Partition object has a Drop method.

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

Upvotes: 1

Related Questions