I have a cube which on a daily basis partitions will be created
I have to process the partition based on the day.
If the day is 03 jan 09
the package has to process shipment2009_01_03 (Full partion processing)
If the current date is 04 jan 09 the package has to process shipment2009_01_04
I have to schedule the package every 2 hrs. so for a day the package should execute 12 times with the current date.
How to do it in SSIs and is there any other way to do this.?