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

3 comments:

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 !

Galia Co Hagan said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
or Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.

soumya Teja said...

you have provided excellent information, Check it once for more information on MSBI Online Training Hyderabad