Hi,
I have a cube which on a daily basis partitions will be created
Partition names:
shipment2008_12_31
shipment2009_01_01
shipment2009_01_02
shipment2009_01_03
shipment2009_01_04
....
.
.
.
.
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
etc...
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.?
Discuss This Question: