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:
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 !
Post a Comment