MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, March 15, 2011

SSAS-Dynamic Cube Partition Refresh

Hi,

Here you can see Refresh the Cube Partition dynamically using SSIS Package.

The steps are involved,
 Drop the existing Partitions on the cube
 Re-Create the Partitions.
Get more details about Cube-Partitions.
http://msdn.microsoft.com/en-us/library/ms175604.aspx
Here is the link to implement Partition at cube level.
http://sql-bi-dev.blogspot.com/2010/12/dynamic-cube-partitioning-in-ssas-2008.html
Download the sampl SSIS-Package here.
http://www.ziddu.com/download/14205603/Cube_Partition.zip.html

Regards,
Ravindra

1 comment:

suresh said...

Hi Ravi,
sampl SSIS-Package is not there..it's showing error:
The file You are looking for... may be deleted by the user or by the Administrator !