How to process partitions (Full) in analysis services
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.?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 12, 2009 6:08 PM
UPDATED:
January 12, 2009 6:36 PM
RELATED QUESTIONS
- Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
- SSIS package using dynamic configurations
- Compare PS file date with current date
- Client cannot join AD2008 domain - computer object disabled
- EXCEL 2003 and VLOOKUP help in calculating percentage in third cell
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
